GlenS Wrote:
Find & Replace works for most of the characters except for a character
which appear at the front of some of the numbers (EG: '354859). I've
tried copying & pasting this character into the Find & Replace but it
doesn't work.

I think it's something that's been entered to force Excel to start
numbers with a 0.

Glen

Hi Glen

The ' allows numbers to be enterred with leading zeros

To get rid of this in the next available column use this formula
=TRIM(A1), change the reference to suit, drag this down to the bottom
of the row, the copy paste special values over the column with the
formulae


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=475327