1

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

1 Answer 1

1

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

2
  • 1
    YOU ARE PURE GENIUS!!! I've been trying various combos since watching that video and all that time, this could be done with just 2 characters! This will save me a lot of trouble! You have no idea how grateful I am! :) :) :D :D I would thumbs up your answers a thousand times if I could! :D
    – Genny
    Nov 5, 2020 at 5:04
  • "I would thumbs up your answers a thousand times if I could". Thank you Genny :) Nov 7, 2020 at 2:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.