![Excel insert text after word](https://kumkoniak.com/103.jpg)
- First, type the following formula in cell D5.
- Let’s go through the following steps to do the task. We will apply the REPLACE function to do the task. In this method, we will add a number code (+889) between the state abbreviation and the numbers of the Number column. Applying REPLACE Function to Insert Character Between Text Read More: How to Add a Character in Excel to Multiple Cells (5 Easy Ways)Ģ.
- At this point, drag down the formula with the Fill Handle tool.Īs a result, in the Result column, you can see the inserted character between text.
-
Explanation: a Hyphen ( –) is added between the abbreviation NY and the numbers 019186 in cell D5.NY& “-” &019186 → the Ampersand operator connects NY with Hyphen(-) and 019186.It begins from the position we specify and returns the number of characters that we specify. MID(C5,3,100) → the MID function returns characters from a text string.The returned characters are based on the number we specify.
LEFT(C5,2) → the LEFT function returns the character or characters from the beginning position in a number or text string of a cell.