Quickly add text or character to multiple cells in Excel

Supposing you have a range of cells and now you need to add or insert text in specific position of the existing text within the cells, how could you do that? To add text or characters to the beginning or end of multiple cells, add text or characters before or after specific characters, or insert text at specified positions of a cell, you can use Add Text utility of Kutools for Excel.

Add text or character to the beginning or end of all cells

Add text or character before or after specific characters

Add text or character after Nth character (insert at specified one or multiple positions)

Add text or character between or around characters, before every uppercase or lowercase letters or numbers

Click Kutools > Text > Add Text. See screenshots:

Add text or character to the beginning or end of all cells

Add text or character to the beginning of cells (before the first character)

For example, you have a range of cell values and you want to add specific text to the beginning of the values, you can do as this:

1. Select the range that you want to insert the same text.

2. Apply this utility by clicking Kutools > Text > Add Text.

3. In the Add Text dialog box, please input the text you want to add in the Text box. And check Before first character under Add position. And you can preview the result from the Preview pane. See screenshot:

4. Then click OK or Apply. The text has been added before the cell values. Note: click OK button will close the dialog box and apply the operation; but click Apply button will only apply the operation without closing the dialog box. See screenshots:

Add text or character to the end of cells (after the last character)

If you need to insert the same text to the end of cells (after the last character), this utility also can help you.

1. Select the range that you want to insert the same text after the last character of existing text string.

2. Click Kutools > Text > Add Text to open the Add Text dialog box, and enter the text you want to add in the Text box. And check After last character under Add position. And you can preview the result from the Preview pane. See screenshot:

3. Then click OK or Apply. And the text has been added after the cell value. See screenshots:

Add text or character before or after specific characters

Add text or character before specific characters

To add the same text before specific characters, please do as follows:

1. Select the range that you want to insert the same text.

2. Apply this utility by clicking Kutools > Text > Add Text.

3. In the Add Text dialog box, please input the text you want to add in the Text box. Check Before text under Add position, and enter the characters you will insert in the corresponding textbox. You can preview the result from the Preview pane. See screenshot:

4. Then click OK or Apply. The text has been added before every specific values. See screenshots:

Add text or character after specific characters

If you need to insert the same text after specific characters, please do as follows.

1. Select the range that you want to insert the same text after specific characters.

2. Click Kutools > Text > Add Text to open the Add Text dialog box, and enter the text you want to add in the Text box. Check After text under Add position, and enter the characters you will insert in the corresponding textbox. You can preview the result from the Preview pane. See screenshot:

3. Then click OK or Apply. And the text has been added after the cell value. See screenshots:

Add text or character after Nth character (insert at specified one or multiple positions)

With this tool, you can add certain text or characters at one or more positions you specified in a cell.

1. Select the range of cells to which you will add the same text after Nth character.

2. Click Kutools > Text > Add Text to open the Add Text dialog box, and enter the text or characters you want to add in the Text box. Then check Specify position and enter a position you want (for example, enter "4"to insert the text after the 4th character). And you can preview the result from the Preview Pane. See screenshot:

Note: You can add text or characters at multiple specified positions simultaneously with entering the text positions and separating them with commas. See screenshot:

3. Then click OK or Apply. And the text has been added to the specified character position. See screenshots:

Or add text or characters at multiple specified positions. See screenshot:

Add text or character between or around characters, before every uppercase or lowercase letters or numbers

If you want to add text or characters between characters or words, around text, or before uppercase/lowercase letters or numeric values, this utility can also help you. Please do as follows.

1. Select the range of cells in which you want to add text or characters, then click Kutools > Text > Add Text to open the Add Text dialog box.

2. In the Add Text dialog box, type the text or characters you will add, select the option you need from the Only add to drop-down menu. And then click the OK or Apply button. See screenshot:

Notes:

1. Instead of typing in the text to be added by yourself, you can click on the icon to extract content of a cell.

2. This utility supports Undo (Ctrl+Z), and the undo is only one level.

3. If you check Skip non-text cells, the non-text cells will be ignored when adding text.

Demo: Quickly add the same text or characters in a range of cells in Excel