How to Add Text in Excel

With the Text Toolkit add-in 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.

Responses

i want to combaine multiple rows data into one

Reply

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!

Reply

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

Reply

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: https://www.ablebits.com/downloads/index.php

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.

Reply

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

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

Hello,

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, version 2018.5.2020.9438.

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

If you're still having any difficulties, please contact us at support@ablebits.com.

Reply

Ask a question (posted publicly)

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.
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

60+ professional tools for Excel
60+ professional tools for Excel
2019–2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard