Geez, it’s like I’m on a PMS streak with using the Find and Replace function! I’ve again stumbled upon another trick when I want to ADD a new word in between two words that occur in multiple cells and rows!

Let’s just say, this is the notification content I am managing with 30 different types of messages and all of these contain variables that begin and end with hash brown hashtag:

Well, you only see five types in the screenshot above because this is just an illustration! Now, I want to add a new word “Expresso” between “PDR” and “#Delivery_No#”. Instead of adding the word 30 times in 30 rows, I use the almighty Find and Replace function to do the job once:

1.  Press the Ctrl and H buttons on your keyboard at the same time.

2.  A Find and Replace dialog box appears. Enter the word “PDR” in Find what. Then, enter the words “PDR Expresso” in Replace with. Click Replace All.

Yup, the trick is just simply finding the word “PDR”, and replacing it with “PDR Expresso” because I want “Expresso” to appear specifically between “PDR” and “#Delivery_No#”. No formula necessary!

If you like this trick, you might wanna check out similar tricks like how to highlight a cell based on a specific word or value and how to remove leading spaces from multiple cells.

I have one more trick up my sleeves and this time it is DELETING! Stay tuned for the next post!