How to add a character before each word in a cell in Excel?
This article will show you a formula to add a specified character before each word in a cell in Excel.
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
Please do as follows to add one or some characters before each word in a cell in Excel.
1. Select a blank cell, enter formula ="Character"&SUBSTITUTE(Cell Reference," "," Character") into the Formula Bar, and then press the Enter key.
In this case, I need to add word “Kutools-” before each word in cell A2, so I change the formula to ="Kutools-"&SUBSTITUTE(A2," "," Kutools-") in the formula bar. See screenshot:
2. Keep selecting the first result cell, then drag the Fill Handle down to get all result as below screenshot shown.
Note: In the above formula, if your text strings are separated by other delimiters, please replace the comma within the formula with the specific delimiter of your own.
- How to add comma at end of cell/text in Excel?
- How to add space between characters or every digit in Excel?
- How to add 1 to a specified cell if cell contains certain text in Excel?