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.
We care about your data. The add-in will back up your worksheet if you select the corresponding option.
Click the Add icon in the Text group on the Ablebits Data tab:
The Add Text pane offers you to adjust the following:
Click the Add Text button and enjoy the result.
Add text is not working in my Ultimate edition for business
Thank you for your message. I have just replied to you by email.
Just bought this add on. Add text is not working. Could you please help. Thanks.
Add text is not working in my ultimate edition too.
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 email@example.com and we'll do our best to make our program work for you.
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?
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 firstname.lastname@example.org. 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).
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 email@example.com.
I don't find where is an text group in excel
Thank you for contacting us.
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
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!