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

Post a comment

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.