replace part text in a cell

[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!

 

[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!

Try this:

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

Regards,
Per

 

[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!

=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

 

[Rick Rothstein]

Or more directly...

=REPLACE(A1,7,1,5)