Forum Discussion
Excel Add Text after first character _
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)
- cer113May 23, 2025Copper Contributor
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
- HansVogelaarMay 24, 2025MVP
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?
- cer113May 23, 2025Copper Contributor
HI
Yes it is working I made little mistake but this is working as expected
thanks a ton
- cer113May 23, 2025Copper Contributor
after entering this into B2
=SUBSTITUTE(A2, "_", "_SYN", 1)
it still makes the same word without word SYN is anything else that needs to be done