On Sun, 28 Dec 2008 02:40:52 GMT, "mkcma via OfficeKB.com" <u48424@uwe 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

What do you mean by "bring the numbers over ..."??

After the values have been pasted into your workbook, you can process to get
rid of the last character. The "best" way to do that depends on what that
character is; and also the nature of your data; and whether that character
needs to be retained anyplace else within the string.

For example, if the character is a <nbsp, you could do Find/Replace

Find What: <alt-0160 Replace with: <blank Replace All
(note that when you type the code for the nbsp, you must enter the
digits using the NUMERIC KEYPAD).

If you want to process the numbers so that when they are "brought over" they
are already correct, you'll need to make changes in your data source reporting
routines; or write a VBA routine to pre-process the files.
--ron