Tag Archives: CONCATENATE

Learn something new from something that I think I knew well…

Posted on October 17, 2018 by

Today is a public holiday in Hong Kong.  A perfect break in the middle of a busy week.  What did I do on a public holiday?  Excel, Excel and Excel. 🙂 I watched a few videos from my favourite YouTube … Continue reading →

Rate this:

Posted in Formula | Tagged , | Leave a comment

Insert a text string into a specific position of another text string in #Excel

Posted on November 25, 2017 by

Turn REPLACE function into “INSERT” function Continue reading →

Rate this:

Posted in Formula | Tagged , | Leave a comment

Pay attention when you concatenate – A1 & B1 vs. A1 & “|” & B1

Posted on February 14, 2015 by

In many case, we may want to combine texts from different cells.  This can be done by either CONCATENATE function or simply an Ampersand &.  E.g. A1 & B1 & C1 …… We may take it for granted as it looks so … Continue reading →

Rate this:

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