Add A New Word In Between Two Words with Find and Replace Function (Excel 2013)

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:

find_and_replace_add_delete_text1

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.

find_and_replace_add_delete_text2
My oh my, ain’t this easy! Look what we have now:

find_and_replace_add_delete_text3

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!

 

Leave a Reply

Your email address will not be published. Required fields are marked *