Excel help please

[Matthew Udovich]

Howdy all, I OCR'd a doc and then copy/pasted into Excel. Unfortunately a few of the numbers ocr'd as P00012345, the P should be a zer0 as well, I tried to do a find/replace, it took out the P, but also all the leading zero's  I'd rather not have to concatenate them back on, any ideas on what to do? The format of the cells is text, in the Find/Replace i changed the format to text (even though it already was text), but the zeros still disappear.

[Andrew Carrick]

Have you tried replacing a string rather than just one character, e.g. P000 to 0000?

[Matthew Udovich]

Thanks for the idea, I tried that, however, I get the same results 

[rteich]

Matthew:

Excel is definitely finicky.  I was able to accomplish this by doing a search & replace and replacing P with '0

This would help with the leading P, but could be problematic with imbedded P's.  Maybe this will get you closer to where you want to be.

Regards,

[Matthew Udovich]

Thanks Randy, as of now, no embedded P's :-) Thanks again.