Tag Archives: FIND

Got the following question: hi, how do i search for a specific combination of characters exclusively i.e. if one cell contains 5A;3B&4C while another cell contains 5AA;3B&4C, and my search criteria is 5A, i want the results to return only … Continue reading →

Rate this:

Writing a long formula is not easy, even for an advanced Excel user. What I mean long is a formula with many nested FUNCTIONS within a single formula. The difficulty I am talking about is not related to whether you understand the … Continue reading →

Rate this:

We talked about RIGHT, LEFT, MID, UPPER, LOWER, PROPER, FIND, SEARCH, REPLACE and SUBSTITUTE in the past few weeks. Now it’s time to put every thing together to solve a problem. This is actually the most amazing part of using … Continue reading →

Rate this:

In many situations, we use either FIND or SEARCH together with LEFT, RIGHT, MID to achieve what we need. A typical example is to extract the first name and the last name from a full name where a coma acts as … Continue reading →

Rate this:

Extract number from a text string This post is about two things: How a poor system set up could drive you crazy? Why being good in Excel could save you lots of time in workplace? Another real work example. I was … Continue reading →

Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques. I had encountered a file with thousands of records (rows) that keeps track of details of different jobs. Finished jobs were identified by Strikethrough … Continue reading →