Excel 2007 : Insert Text into string

**skidz** · 11-12-2010, 12:16 PM

I need to insert the number 11_ after the second _ in column A. I was trying to this with a concatenate and multiple (LEN,LEFT,MID) Functions.

BS_NU_SilexGrey
BS(AC)_NML_Brookstone

Should look like this.

BS_NU_11_SilexGrey
BS(AC)_NML_11_Brookstone

**arthurbr** · 11-12-2010, 12:20 PM

Hi try

=SUBSTITUTE(A1,"_","_11_",2)

**skidz** · 11-12-2010, 12:26 PM

Originally Posted by arthurbr

Hi try

=SUBSTITUTE(A1,"_","_11_",2)

Perfect. Thanks! I knew there was an easy way to do it. I've not used the substitute function before.

**arthurbr** · 11-12-2010, 12:30 PM

How did you know it was an easy way without knowing how to do it?

**skidz** · 11-12-2010, 12:50 PM

Originally Posted by arthurbr

How did you know it was an easy way without knowing how to do it?

LOL. I knew there had to be a function for it. The function is pretty self explanatory. I've just never used it before. Thanks again! I'll remember that one.

**arthurbr** · 11-12-2010, 12:56 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save