Hi all,
Realize how much time and effort everyone is putting into helping me,
and want to make sure that you know how much I appreciate it.
A bit more:
The data came from a table of radio frequencies, and their
descriptions,I copied and pasted into Excel 2007.
I then formatted it as a .csv and did a Text to column operation on it
to put the number, and it's description, in separate columns
My guess is that this is where the problem arises from.
As mentioned, it is likely that there is some "hidden code", or... from
either, or both, of these operations.?
Anyway, here's a small snip of what is happening.
Won't let me Paste it, but this is what it shows:
2657 2657 K
2657 2657K
In the first row, is a normal copy and paste from the data.
Doing the operation on it, yields the "space" we are all talking about.
The second row down, I just wrote the number, and the operation yields
no space, as expected.
Visually, both 2657's appear to be in the extreme left hand position in
their cell, and both as best I can tell are formatted as regular Text
(but possibly not, or with something hidden ?).
They sure do look the same.
So, there must be something hidden in the data.
I will play around with this some more, read the excellent links that
have been suggested, and if I find out what the problem was, will Post
back here.
Thanks again,
Bob
--------------------------------------