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...
Maybe your "_" is in ASCII code point.
Try this:
=SUBSTITUTE(A2, CHAR(95), "_SYN", 1)