Forum Discussion
Excel Add Text after first character _
Hi I was asking people to help me with adding text and although I hoped they may have answer none of 30 excel day to day excel people could help me and I am hoping that there is bigger expert her...
Let's say you have such a text in A2.
In B2, enter the formula
=SUBSTITUTE(A2, "_", "_SYN", 1)
This can be filled down. Or if you want to fill rows 2 to 100 in one go, use
=SUBSTITUTE(A2:A100, "_", "_SYN", 1)
HI
Yes it is working I made little mistake but this is working as expected
thanks a ton