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

Ron Rosenfeld wrote:
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 - 7 lines]
any suggestions?
thanks

Most likely, your data is not identical.

You should be able to "prove" this by formulas.

For example, if A1 contains a part number and Cdn!H7 contains the matching part
number, if they are identical then:

=A1=Cdn!H7 -- TRUE
=len(a1) = len(Cdn!H7) -- TRUE

etc.

The most common "invisible" character is an <nbsp CHAR(160) at the end of your
data.

--ron

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