How to add strings of text to multiple cells in Excel?
Adding specific text to multiple cells in Excel can be a tedious and time-consuming task if done manually, cell by cell. Fortunately, there are more efficient methods available that can help you insert specific text into multiple cells quickly and easily. This guide outlines these methods, providing you with the tools to streamline your workflow.
- Compare VBA and Kutools for adding text
- Add specific text to multiple cells in Excel with VBA
- Add specific text to multiple cells in Excel with Kutools for Excel
Compare VBA and Kutools for adding text
Both VBA and Kutools for Excel can add the same text to multiple cells at once, but they differ significantly in setup, flexibility, and ease of use. The following comparison can help you choose the more suitable approach.
| Method | Best for | Setup required | Text placement | Ease of use |
|---|---|---|---|---|
| VBA | Users who are comfortable with macros and want customizable automation | Requires opening the VBA editor, inserting a module, and running code | Can be customized by editing the VBA code | Requires VBA knowledge, especially when changing how or where text is inserted |
| Kutools for Excel | Quickly adding text to many existing cells without writing code | No coding or macro setup required | Built-in options for adding text before, after, or at specified positions within existing text | Very easy — select the range, enter the text, choose a position, and apply |
Add specific text to multiple cells in Excel with VBA
Using a VBA can ease our work and add specific text in multiple cells without copying and pasting.
Step 1: Select the cells in which you will add the specific text.
Step 2: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
Step 3: Click Insert >> Module, and paste the following macro in the Module Window.
VBA code: Add text to selected cells in Excel
Sub Add2Formula()
'Updated by Extendoffice 2024/07/23
For Each c In Selection
c.Activate
ActiveCell.FormulaR1C1 = "Excel - " & ActiveCell.Formula
Next c
End Sub
Step 4: Press the F5 key to run this macro.
Add specific text to multiple cells in Excel with Kutools for Excel
For common users of Microsoft Excel, we may be not familiar with VBA. Alternately, the Kutools for Excel's Add Text tool can help us add specific text or strings in multiple cells quickly and easily.
Step 1: Select the cells in which you will add the specific text.
Step 2: Click the Kutools > Text > Add Text. See screenshot:
Step 3: In the Add Text dialog box, enter the specific text and characters in the Text section.
Step 4: check a position where you will add the specific text at in the Position section. (Note: if you want to insert the text in a specified position, please check Specify and specify the position.) See screenshot:
Step 5: Click OK or Apply.
The Add Text tool of Kutools for Excel supports us in adding any specific text and characters before or after the original cell text. What's more, we can add specific text between original cell texts. No matter which settings you set, you can preview the cell changes in the Preview section.
Related Article:
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in