Quick Links
Summary
To add text to the beginning or the end of your existing text, use the “&” operator or the CONCAT function. Using other functions, you may add text at the nth character or before or after a specific character.
Do you want toadd some textto the beginning, middle, or end of the existing text in your cells? Microsoft Excel has you covered. You can use a formula or function to append text to your cells, including finding a specific character and adding your text before or after it. Here’s how.
Add Text to the Beginning of a Cell
To add some textbefore your existing text in a cell, simply use the&(ampersand) operator or theCONCATfunction. Both work the same way.
To use them, first, open your Excel spreadsheet and select the cell where you want to display your merged text.
In the chosen cell, type the following formula and press Enter. In this formula, replaceMr.(note the space after the text) with the text you want to add andB2with the reference of the cell where you want to append your text.
Note that we’ve enclosed the text to add in double-quotes. You can add any text, spaces, numbers, or symbols within these quotes, and Excel will append them to your existing cell content.
If you’d like touse theCONCATfunction, then in the cell where you want to display the result, enter the following function and press Enter. Here, replaceMr.with the text to add andB2with the cell reference where your existing text is.
Your result will look like the following:
Related:How to Add Space Between Text and Cell Borders in Excel
Add Text to the End of a Cell
To append your custom text at the end of your existing text, use the same&(ampersand) operator or theCONCATfunction.
If you’d like to use the&operator, then in your Excel spreadsheet, click the cell where you want to display the result.
In the selected cell, type the following formula and press Enter. Here, replaceB2with the cell where your existing text is and(Journalist)with the text you want to append.
There’s a space before(Journalist)so that this custom text adds a space right after your existing text ends.
If you’d like to use theCONCATfunction, then in your chosen cell, enter the following and press the Enter key. Once again, replaceB2with the cell containing your existing text and(Journalist)with the text you want to add.
And here’s what the result will look like:
Related:How to Add Alternative Text to an Object in Microsoft Excel
Add Text After a Specific Number of Characters
Excel allows you to add custom text after the specified number of characters in your existing text or after a specific character.
To add your text after a specific number of characters, use theLEFT,RIGHT, andLENfunctionsin combination with the&operator.
For example, to add a-(hyphen) after the second character in theC2cell’s content, select the cell where you want to display the result.
In the selected cell, type the following formula and press Enter. Here, replace all instances ofC2with your cell reference,-(hyphen) with the text you want to add, and2with the number of characters after which you want your custom text to appear.
Soon as you press Enter, Excel will add the specified text and display the result.
Add Text After a Specific Character
In case you want to add text after or before a specific character in a cell’s text content, then use Excel’sLEFT,SEARCH,RIGHT, andLENfunctions.
For instance, to add212(NYC’s area code) after the#(hash) symbol, you’ll use the following formula. Here, you’ll replaceC2with the cell where your existing text is,#with the character after which you want to append your text, and212with the text to add.
You’ll see the result in your selected cell.
Once you’ve used a formula or function from the above sections, you canautomatically copy it for all your recordsin the sheet. To do that, from the bottom-right corner of the cell where you’ve entered your function or formula, drag downwards until all your records are covered. And that’s all.
Is your concatenated text not fitting Excel’s default cell size? There’s a way toshrink or expand your cells.
