Replacing one character with another in a string

user_1530886 0
Viewed 77843

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 like

A:B:Z:D

How can I do it?

formula delimiter extract excel replace
2 Answers
Related