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...
it works only if the sheet is new if I try to do it in another sheet then after I press enter it just puts substitute text and it doesnt replace
after i put formula in new sheet this replacement text
=SUBSTITUTE(A2,"_","_SYN01_",1)
for some sheets it works for some doesnt
It should work on all sheets. Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?