| Add Text - The all-round tool handles adding text in Excel |
| Effecient . Professional . Security |
 |
 30-Day Free Trial |
 Buy once, Use Forever |
 60-Day No Reason Refund |
 2-Year Free Upgrade |
5 Revolutional Features 
| Add At Beginning Of Cells | 1 |
| Add text at the front of first characters in all selected cells at once time | |
 |
|
| Add At End Of Cells | 2 |
| Add text at the end of last characters in all selected cells | |
 |
|
| Add At Specific Position(s) Of Cells | 3 |
| Add text at any positions of cells, such as add - at the end of 3rd and 5th characters | |
 |
|
| Add At Beginning Of These Characters | 4 |
| ○ Uppercase Letters ○ Lowercase Letters ○ Alphabetical Chars ○ Numeric Chars | |
| Example below: Add space at the front of every uppercase letter | |
 |
|
| Skip Non-Text Cells | 5 |
| Tick Skip Non-text Cells checkbox, Add Text tool only works at the text cells | |
 |
|
Farewell To Old Ways, Enjoy A New Experience
| Manual | Formula | VBA | Kutools | |
| Support Big Data |  |
 |
|
 |
| Stability & Security | |
|
|
|
| Multi-Selections | |
|
|
|
| Support Undo | |
|
|
|
| Easy To Use | |
|
|
|
| Preview | |
|
|
|
| Support and easy Support but hard sometimes Not Support |
|
Double-Insurance At Data |
 |
| The old ways may lead to original data losing when deal with data, but the Add Text tool provides double protections for the original data | |
|
>> Preview adding results before operation |
|
Batch Operation, Save Time Save Labour |
 |
| Whatever are continuous or incontinuous ranges, select them then apply Add Text, text adding has been done in multi-cells at once | |
|
◇ Incontinuous cells: hold Ctrl to select |
|
Without Any Skills |
 |
| No need complex formulas and VBA code, just move mouse to clicks, the text adding has been completed | |
|
Real-Time Preview, What You See Is What You Get |
||
 |
 |
 |
| View operation result in advance | Make sure data entering correctly | Avoid unnecessary reworking |
|
Drink A Cup Of Coffee, Jobs Have Been Done |
|||||
 |
 |
 |
|
 |
|
| Select Cells | Setting | Click OK | |||
| More Kindly Features, Free You From All Anxiety | |
 |
 |
| Support most of versions | For all users |
 |
 |
| Operate at original data | Record recently used texts |
|
Kutools |
VS |
Other Add-ins |
| View results in Preview pane | Preview | No preview, directly operate |
| Passed thousands of tests | Stability | May lead to data lose or crash |
| Process big data in seconds | Speed | Process slowly or no support |
| Support Undo and Ctrl+Z | Undo | No support Undo |
| Kindly Pre-Sales, Professional After Sales | ||
 30-Day No Limited Free Trial |
 |
|
| 60-Day No Reason Full Refund |
||
| Buy Once Time, Use Forever |
||
| 2-Year Free Upgrade |
||
| 24 X 7 Email Service Support |
||
| Get 300+ Features At Once |
||
In Kutools for Excel, Add Text is one of its dozens of text editing tools. In addition, Kutools for Excel has more than 300 tools which can simplify various kinds of complicated tasks into a few clicks in Excel. For example, combine multiple workbooks worksheets with several clicks, easily count and sum data based on color, split data into multiple rows or columns in seconds and so on. It supports Excel versions 2007-2019 and Office 365. No doubt, it is a powerful add-in you needed.