Video: how to add text to multiple Google Sheets cells

We have plenty of useful add-ons to manage text in spreadsheets. Add Text is one of them. Watch today's video to learn how to insert the same text to multiple Google Sheets cells: at the beginning & at the end of cells, after the Nth character, before/after a certain text string.

Video transcript: Add Text add-on for Google Sheets

Whenever you need to insert the same text to multiple Google Sheets cells, our Add Text add-on will prove extremely useful.

It will add your characters or text strings without any formulas to 5 different positions:

  • At the beginning of all selected cells at once.
  • Or, on the contrary, at their end.
  • At a certain position defined by a number.
  • Before any existing text that you specify.
  • Or, instead, right after that text.

Let me show you that adding text in Google Sheets is really that easy.
Insert text to 5 positions in Google Sheets cells.
Here I have a short book list that I want to look complete and presentable.

To begin with, install Power Tools to your spreadsheets and run it from the Add-ons menu. Go to the Text group and you'll see the Add text tool.

Now you're 3 steps away from the result:

  1. First, select those cells where you want to insert the text.
  2. Then, enter the text that you want to add to your cells into this special field of the add-on.
  3. And finally, select the position where that text will go.

By the way, there's this option at the bottom that will tell the add-on not to add anything into empty cells of your selected range.
Add text at the beginning of cells.
I'm going to add this birth year to the beginning of my selected cells. I pick the corresponding option, press Run, and, as expected, the tool adds my text at the very beginning of all these cells.

To insert text to the right side of cells, I pick the next option — at the end. I will add first names to the first column. Let me just enter another string I need to add... a-a-and there it is — the new text at the end of all cells.

You can also insert the text at a certain position inside the existing data. For that, choose after character number and enter the desired position.

If your new text should precede some particular existing string, select the before text option and enter that particular text. The add-on will look for it in all selected cells, and insert your new text right before each and every found instance.

If, on the contrary, your new text should follow that string, select after text instead, enter the string, and hit Run. Now the new text is added to the right of all found occurrences of the desired string.
Insert text after another text string.
And that's it! Now you know how ridiculously easy it is to insert the same text in Google Sheets cells.

Install your Power Tools from the Google Sheets store to make all use of this and over 30 other time-savers for your spreadsheets.

If you have any questions, feel free to leave a comment or contact us directly — we'll be happy to help!

You may also be interested in

Table of contents

Post a comment



Thank you for your comment! When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to your query. We cannot guarantee that we will answer every question, but we'll do our best :)