Search and replace - simple question, i hope!

Posted by Dave on February 05, 2002 6:13 AM

Hi all.

I hav OCR'd lots of data and the format of the original is "XXX." or "YYY.YY" mixed up in the same column.

Is there a way to search for the cells which end with a decimal point and replace them with ".0" so i end up with "XXX.0" and "YYY.YY" without affecting the "YYY.YY" values?

Put simply (!?!) i want to append 0's to those data which don't already have them.

Cheers in advance for your help,

Dave

Posted by Brian on February 05, 2002 6:58 AM

How about this, the data is in column A. Enter this formula into column B:

=IF(RIGHT(A1,1)=".",CONCATENATE(A1,"0"),A1)

and copy down.

Posted by Dave on February 05, 2002 7:15 AM

Nice! Thanks (nt)