Tag Archives: CONCATENATE

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

Posted on October 17, 2018 by MF

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 MF

Turn REPLACE function into “INSERT” function Continue reading →

Rate this:

Posted in Formula | Tagged , | 5 Comments

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

Posted on February 14, 2015 by MF

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