Changing part of string

[Lavina]

Hello guys,

I have a string in which i want to find a part, and once found replace it with a different string.

Say i have: abcd1abc

I want to find the part cd1 and replace it with cd2

Replace(ActiveCell, "cd1", "cd2")

But i want to replace text: cd(any number) with cd2.

And as far as i see wildcard cd* does not work in replace functions, and replacing without the number doesn't work either, how should i tackle this?
I can find position in string, make a cut off, then add the 3 strings together, but maybe there's something better?

 

[kweaver]

SEARCH takes a wild card.
Does the "cd#" occur only once? I played around with SEARCH and this will work although not particularly elegant.

=LEFT(A1,SEARCH("cd*",A1)+1)&"2"&RIGHT(A1,LEN(A1)-(SEARCH("cd*",A1)+2))

 

[Lavina]

In that cell only once yes, great solution, thank you very much!