How do I stop Excel from converting text to number format?

[RHONDAK72]

I have some cells that begin with "zz000123". I need to remove the "zz" but I also need for the "000" to stay in tact. The cells in the column are formatted as Text. But when I do the Edit-Replace function to replace "zz" with "", it takes off those 3 zeros as if it is converting it to a number format. I do not want that. What can I do to keep "000" in place?

 

[Special-K99]

=RIGHT(A1,6) and copy down the column

 

[Russ At Index]

Hi RHONDAK72,

Assuming your data is always uniform in length , you could
insert a column next to your data & use the formula beow:

=RIGHT(A1,7)

This is assuming 9 characters , it will remove the zz prefix
where neccessary , but if you have no zz prefix it will still
report the 7 digits , alpha & numeric.

Example1 : ZZOOO1234 = OOO1234
Example2 : OOO1234 = OOO1234

HTH

Russ

 

[drsarao]

Try to edit replace "zz" with "'" (single hyphen)

 

[RHONDAK72]

Unfortunately, the length varies. Some cells are 9 digits and some are longer.

 

[drsarao]

Edit-Replace zz with ' (single hyphen) works. I tried.

 

[RHONDAK72]

thanks!