Tag Archives: Trim

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

Extract last word from a text string

There are many cases that we may just want the last word from a text string.  Typical example would be something like the last row in the above screenshot: There are many codes at the end of a text string … Continue reading

Rate this:

Posted in Excel Tips, Formula | Tagged , , , | 5 Comments

Advanced vlookup – Text vs. Number

Why does vlookup not return the lookup value? I am sure it is in the source data table.  I see it by my eyes. Have you ever experienced this?? That’s normal when you import your data from other database.  Fortunately … Continue reading

Rate this:

Posted in Formula | Tagged , , | 14 Comments