Google Sheets – Use Regular Expressions to Add Text to Beginning or End of Cells

formulasgoogle sheetsregexregexplacesearch

I have a bunch of words in a sheet in one column, e.g.:

Study Guide 101 
Meditation for Beginners Cheatsheet 
Lose Weight Fast

What I want to do is add a word to the end of these in the cell using Find & Replace (not a formula), through regular expressions, without using a formula or anything in another cell.
The word to add would be - EBOOK

The same way can we can text to the front of the strings in cells, in this case DD-EB- (just an example).

I'm not sure whether this is entirely possible, but I got the idea from this youtube video:
https://www.youtube.com/watch?v=OVzXpLJRcQk

Best Answer

How to Add Text to Beginning or End of Cells without a formula

Please follow these steps

  • Step 1
    Go to the top menu --> Edit --> Find and replace

  • Step 2
    From Search choose Specific range and clicking on the little icon pick your range.

  • Step 3
    Check the Search using regular expressions and un-check Match case

  • Step 4

    • To add text in the end, on the Find field use $
    • To add text in the beginning, on the Find field use ^

  • Step 5
    On Replace with fill in DD-EB- or - EBOOK

  • Step 6
    Press on Find and then on Replace (to replace one by one) or Replace all for one go.

  • Step 7
    Click Done

  • Step 8
    Enjoy your newly created text :)

enter image description here

Related Topic