How to really add text to multiple cells without having to re-enter anything in Google Sheets? (No formula used)

I found a Reddit page that uilize 'Find and Replace', but it does not working as intended. It adds text to the end of the cells content. So, I tried with special characters and boom! I found it!!! 

How to add text to the front of multiple cells using Find and Replace:- 

1. Select the cells, 
2. Edit -> Find and Replace (Ctrl+H), 
3. type ^ in 'Find',
4. type your text or numbers or whatever in 'Replace with', 
5. tick the 'Search using regular expressions', 
6. click 'Replace all', 
7. Done! (It should says 'Replaced # instances of ^ with (your text)) 

 

How to add text to the end of multiple cells using Find and Replace:- 

1. Select the cells, 
2. Edit -> Find and Replace (Ctrl+H), 
3. type $ in 'Find',
4. type your text or numbers or whatever in 'Replace with', 
5. tick the 'Search using regular expressions', 
6. click 'Replace all', 
7. Done! (It should says 'Replaced # instances of $ with (your text)) 

 

Oh. I forgot to mention: 

If you want to add space, just type into the textbox 'Replace with'. If you didn't, the text will be sooo close together.

 

Sauce: 

• Original info from Reddit: [ https://www.reddit.com/r/googlesheets/comments/tfqzp6/add_text_to_multiple_cells_without_replacing/?rdt=60221 ], 
• or use Concatenate function in Google Sheets : [ https://support.google.com/docs/answer/3094123 ], 
• or add Power Tools extension into your Google Sheets = [ https://www.ablebits.com/docs/google-sheets-add-text/ ] paid subscription extension <-- at first I'm doing this, but out of curiosity I tests the special character too and found out the ^ stuff X-D 
• or maybe you want to experiment with other characters? Google Sheets function list = [ https://support.google.com/docs/table/25273?hl=en ]. 
• learn Find and Replace Google Sheets = [ https://support.google.com/docs/answer/62754 ].
  

 

Done! Profit! Bye!