replace part text in a cell

I

Indra

How can I replace the 7th item in each cell of the examples below to say 5?

30-02220.900.LAU should be changed to say 30-02250.900.LAU
40-02430.000.FIN should be changed to say 40-02450.000.FIN
10-02210.520.005 should be changed to say 10-02240.510.004

Many thanks!
 
P

Per Jessen

How can I replace the 7th item in each cell of the examples below to say 5?

30-02220.900.LAU should be changed to say 30-02250.900.LAU
40-02430.000.FIN should be changed to say 40-02450.000.FIN
10-02210.520.005 should be changed to say 10-02240.510.004

Many thanks!
Click to expand...

Try this:

=LEFT(A1,6) & 5 & MID(A1,8,LEN(A1)-7)

Regards,
Per
 
R

Ron Rosenfeld

How can I replace the 7th item in each cell of the examples below to say 5?

30-02220.900.LAU should be changed to say 30-02250.900.LAU
40-02430.000.FIN should be changed to say 40-02450.000.FIN
10-02210.520.005 should be changed to say 10-02240.510.004

Many thanks!
Click to expand...


=REPLACE(A1,7,1,5)

will do it but your third example appears to be incorrect -- you have replaced
the 7th character "1" with a "4"
--ron
 
Top