I have First and last names that were downloaded from a website. The names
appear to be separated by a space, but low and behold when I tried to use
text to columns to separate them it did not work. I had to go and change
what ever is separating the name to a space on one of the records to get it
to work. Any ideas on how to accomplish this and what might possibly be
separating the names.