Tag Archives: CONCATENATE

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

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

Turn REPLACE function into “INSERT” function Continue reading

Rate this:

Posted in Formula | Tagged , | 4 Comments

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

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