replace first 1 of a string

[simone77]

Hi all,

I have cells of length 5, formatted like text, that include a series of 0 or 1.
For instance:

01001
10010
00010
01011
11100

I want to replace the first 1 of the string (whatever its position in the string) for a specific value, i.e. an "A".
Any hint?

Thanks for any help

[JieJenn]

Ignore this post. I need to learn how to read.

[NBVC]

Try:

=SUBSTITUTE(A1,1,"A",1)

[simone77]

Thanks, it works.

Try:

=SUBSTITUTE(A1,1,"A",1)