How to Add Text in Excel

With text tools from Ultimate Suite for Excel you can easily append text to the selected cells in your table. Add a prefix, suffix, string, or any characters you may need in the selected range in Excel. Choose to add your text at the beginning or end, before or after certain values, or specify the exact position for your text in the selected cells.

Before you start

We care about your data. The add-in will back up your worksheet if you select the corresponding option.

How to add text to cells in Excel

Click the Add icon in the Text group on the Ablebits Data tab:
Add text to cells in Excel.
The Add Text pane offers you to adjust the following:
How to add text in Excel.

  1. Select the range where you need to append text.
  2. Click the Expand selection icon to select the whole table automatically.
  3. Type the prefix, suffix, string, or characters you need to add to the selected cells in your Excel table.
  4. The values you enter are saved in the dropdown list for future use.
  5. Choose to add text at the beginning or at the end of the cell contents in the selected range.
  6. Insert the specified value before or after the text you enter in the corresponding fields.
  7. Specify the exact position for your text in the selected cells. You can type or choose the character position number and the way to count it: start from the beginning of the cell or from the end of it.
  8. Select Skip empty cells if you have blanks in your data which you don’t want to be processed by the add-in.
  9. Choose Process only text cells to leave the cells with numerical data intact.
  10. We recommend you to Back up this worksheet, as you can't cancel changes made by add-ins in Excel.

Click the Add Text button and enjoy the result.

Responses

Sophia Rous says:
August 20, 2020 at 3:00 am

Add text is not working in my Ultimate edition for business

Priya Raj says:
November 23, 2021 at 12:01 am

Add text is not working in my ultimate edition too.

Katerina Bespalaya (Ablebits Team) says:
November 23, 2021 at 8:50 am

Hello Priya,

Thank you for your comment. Sorry to hear that you are having difficulties with our add-in.

Could you please specify what version of Ultimate Suite is currently installed in your Excel? - Click Help -> About under the Ablebits Data tab in the Ribbon to check the version number. Also, please describe the problem with the Add Text tool in more detail. Any screenshots illustrating the issue would help a lot.

Please email the requested information to support@ablebits.com and we'll do our best to make our program work for you.

Jessica LoVerso says:
July 16, 2020 at 11:23 pm

I am merging data from multiple data sets, and in some cases, the numbers are written as xx$ and in other cases simply xx- without the % but it is still a percentage. I tried to use your 'add text' function to simply add a % at the end of the cells without, but it will not process this command. is there another way?

Giorgos says:
June 10, 2020 at 6:01 am

I cannot type any text in the fields of the add in. I have to paste whatever I want and only by right clicking and paste (ctrl+v is not working either).

sasi says:
August 21, 2018 at 5:10 am

i want to combaine multiple rows data into one

Post a comment

Seen by everyone, do not publish license keys and sensitive personal info!

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.