Find any 'D' and replace with 'P'

[Teak]

Hi,
I have a list of 8-letters code such as 'TCGDxxxx' or 'TDADxxxx' etc
I need to replace any Ds with Ps.
My problem is D can be found in any position.
How to do this?

 

[Harlan Grove]

I have a list of 8-letters code such as 'TCGDxxxx' or 'TDADxxxx' etc
I need to replace any Ds with Ps.
My problem is D can be found in any position.
How to do this?

Edit > Replace finding D and replacing it with P?

 

[Leo Heuser]

Hi Teak

Have a look at the SUBSTITUTE() function.