Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
x
or
x
Register  \/ 
x

or
Add Text - The all-round tool handles adding text in Excel
Effecient . Professional . Security
add text final
free use   30-Day Free Trial all life use   Buy once, Use Forever
free refound   60-Day No Reason Refund 2 year update   2-Year Free Upgrade

5 Revolutional Features    circle

Add At Beginning Of Cells 1
Add text at the front of first characters in all selected cells at once time
eg 02
Add At End Of Cells 2
Add text at the end of last characters in all selected cells
eg 02
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
eg 03
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
eg 02
Skip Non-Text Cells 5
Tick Skip Non-text Cells checkbox, Add Text tool only works at the text cells
eg 05

Farewell To Old Ways, Enjoy A New Experience

  Manual Formula VBA Kutools
Support Big Data no suport no suport no suport easy
Stability & Security no suport no suport no suport easy
Multi-Selections no suport no suport no suport easy
Support Undo easy easy no suport easy
Easy To Use no suport no suport no suport easy
Preview no suport no suport no suport easy
easy  Support and easy         no suport Support but hard sometimes         no suport Not Support

Double-Insurance At Data

protect
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
>> Support Undo to restore original data

Batch Operation, Save Time Save Labour

batch operation
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 formula vba
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

preview correct enter save time and money
View operation result in advance Make sure data entering correctly Avoid unnecessary reworking

Drink A Cup Of Coffee, Jobs Have Been Done

correct enter arrow step correct enter arrow step correct enter
Select Cells   Setting   Click OK
More Kindly Features, Free You From All Anxiety
all versions all users
Support most of versions For all users
operate in original data record
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 \
free trial refund buy once
service support service support 300 features

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.