Replacing one character with another in a string
77,828
=SUBSTITUTE(A1,"C","Z")
Although I wasn't clear on whether you wanted G
or Z
, you mentioned G
but your example output shows Z
.
Author by
Admin
Updated on July 09, 2022Comments
-
Admin almost 2 years
I have a data like below:
A:B:C:D
and I want to replace the
C
with data (say,Z
) so that it may look likeA:B:Z:D
How can I do it?