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 , | Leave a comment

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