Changing Codes

C

cj21

I have a series of product codes that all begin with a zero e.g 0455
0343, 0325.

I want to change all the zeros to a 9 is there a quick way of doin
this?


Chri
 
D

Dave Peterson

Maybe using a helper cell and using a formula?

="9"&mid(a1,2,255)

(255 is just a very big number to get the remainder of the text.)

If these are numbers just formatted to show the leading 0, maybe:

=9000+a1

You could also put 9000 in an empty cell.
edit|copy
select the range to change
edit|paste special
click Add

and clean up that 9000 helper cell.
 
Top