Tag Archives: SEARCH

Text manipulation with Excel functions

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:

Posted in Formula | Tagged , , , , , , , , , , | 6 Comments

FIND vs. SEARCH

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:

Posted in Formula | Tagged , | Leave a comment

Make impossible possible

Convert text of specific pattern like “1d 2h 3m 4s” into real time (26:03:04) in Excel To kick start the Year of Monkey, let’s challenge the apparently impossible… Do you think it is not possible in Excel?  If you do, you … Continue reading

Rate this:

Posted in Formula | Tagged , , , , , | Leave a comment