How to Add Text to a Cell With a Formula in Excel

To add text to the beginning or the end of your existing text, use the “&” operator or the CONCAT function. Using other functions, you can add text at the nth character or before or after a specific character.Do you want to add some text to 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 text before your existing text in a cell, simply use the & (ampersand) operator or the CONCAT function. 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, replace Mr.  (note the space after the text) with the text you want to add and B2 with the reference of the cell where you want to append your text. =”Mr. “&B2 Note that we’ve enclosed the text to add in double-quotes. You can add any text, spaces, number… Click below to read the full story from How To Geek
Read More