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. Easily 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 file 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 highligh 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 drop-down list for future use.
  5. Choose to add text before or after the values in the of interest.
  6. Insert the specified value before or after the text you enter in the corresponding field.
  7. Specify the exact position for your text in the selected cells. You can type or choose the character number and the way to count it: start with the beginning of the cell or from the end of it.
  8. Tick the checkbox Process only text cells to leave the cells with numerical data intact.
  9. Select to Skip empty cells if you have blanks in your data table.
  10. We recommend you to Back up the worksheet, as you can't cancel changes made by add-ins in Excel.

Press the Add text button and enjoy the results.


Add text is not working in my Ultimate edition for business


Hello Sophia,

Thank you for your message. I have just replied to you by email.

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?


Hello Jessica,

Thank you for the comment. For us to be able to help you better, please send us a small sample workbook with your source data and the result you expect to get to I kindly ask you to shorten the table to 10-20 rows. We'll look into your task and see if our software can help.


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).


Hello Giorgos,

The problem you described is a known issue caused by one of the Windows updates. Please follow the recommendations from the comments above to solve it. If you have any questions or need further assistance with our add-in, please email us at


Hello there,

Using Add Text, Remove Text, etc options typing specific caracters does not work in my Excel Profesional Plus 2016 . Very fustrating.

Could you check this bug please.

Best regards

Katerina Bespalaya says:
September 5, 2019 at 5:46 pm


Sorry to hear that you've encountered this problem. The issue may occur due to the recent Windows update. We have already published a hotfix, please make sure that you have the latest version of Ultimate Suite installed on your computer.

You can download and install the latest update using this link.

If you're still having any difficulties, please contact us at


I am having the same issue as Unai but my version is Excel 2019, does not allow me to type in the text that I want to add. Nor can I type in text for the "before text" and "after text" boxes.

Hello Sean,

Thank you for your comment. As Katerina mentioned above, this issue is caused by one of the Windows updates. We have already fixed it in the latest version of our Ultimate Suite, please install it and make sure everything works fine:

Thank you.

I don't find where is an text group in excel


Hello Pari,
Thank you for contacting us.

If you want to use our Add Text tool, you need to install our Ultimate Suite for Excel first:

Once it is installed, please go to the Ablebits Data tab in your Excel Ribbon and find the Add icon in the Text group there.


i want to combaine multiple rows data into one


Hi Sasi,
thank you for your comment. Depending on your task, you can use Merge Cells, Merge Tables, or Merge Duplicates Wizard. All these tools are part of Ablebits Ultimate Suite for Excel, you can download the free trial version here.
Also, have a look at our blog post and video on how to combine rows in Excel.
I hope this will help you!


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