Use the Trim or CLEAN function to clear unwanted characters,
eg.
=TRIM(your data) or =CLEAN(your data)

Look at Help, there's some examples


HTH

Pls click the Yes button if this help.

cheers, francis

mkcma wrote:
I did a length count and one set has 8, the others have 7 - and 10 vs 9 etc.

How can I bring the numbers over without that last space?

=(left7) ??

tks,
mk

I believe I have tried everything and cannot get these particular two
worksheets to bring me the matching data - there are over 6,000 lines so I
[quoted text clipped - 18 lines]

--ron

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200812/1