Excel help please

Started by Matthew Udovich, May 04, 2010, 04:26:27 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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?
Jelf Insurance Partnership
Hull, East Yorkshire, UK
Me and TAM used to have a thing but we've split amicably. She got the kids, I got the Camaro and the maid.

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,
Randy Teich
Teich Data Services LLC
randy@teichdataservices.com

Matthew Udovich

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