Monthly Archives: November 2014

Combine contents in a range of cells into a single cell, with no VBA nor formula.

Posted on November 22, 2014 by

  Well, the first thing in your mind maybe using ampersand &  or CONCATENATE to combine them. =A1&” “&A2&” “&A3&” “…… =CONCATENATE(A1,” “,A2,” “……) which is more or less time consuming. Two ways to achieve this quickly Using a combination of … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 6 Comments

Extract last word from a text string

Posted on November 17, 2014 by

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

Date Formats – A trick to format date with “st”, “nd”, “rd”, “th”

Posted on November 8, 2014 by

Well, there is no such custom format for date in Excel… However it can be achieved indirectly, with helper cell 🙂

Rate this:

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