Bryan Hessey Wrote:
Try a =Trim(A1) to remove trailing spaces. These would be detected by
the =Len(A1) formula, and are removed in the trim function.
After the trim, you can Copy - and Paste Special = Values back over the
original data.
Hi Brian,
I've tried a =Len(a1) and it does reveal that a sample field is
length=4, the visible field being '30.5'. However, I've done a trim and
tried paste special, values, to no avail. Checking the same field still
reveals a length of '4'.
Argh! Any more ideas?
Cheers,
Baldy
--
BaldySlaphead
------------------------------------------------------------------------
BaldySlaphead's Profile:
http://www.excelforum.com/member.php...fo&userid=1260
View this thread:
http://www.excelforum.com/showthread...hreadid=489748