Replacing one character with another in a string

excel replace extract formula delimiter
combo picture combo · Jul 17, 2012 · Viewed 77.8k times · Source

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?

Answer

JimmyPena picture JimmyPena · Jul 17, 2012

=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.

Related questions

Excel escaping quotes or apostrophes in cell values

I get a lot of database information from clients in excel spreadsheets. I frequently need to insert/update this data back into the database. I often use excel to generate the insert and update statements via concatenating a bunch of …

Read More
Function to extract remaining string after last backslash

I need an Excel function that can extract a string after last \ from a path and if no \ found then take the whole string. For example: D:\testing\rbc.xls output will be rbc.xls D:\home\testing\test1\script1.…

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More