Text to Columns

Hi Gemma, Thank you for your post, in answer to your question; well you can but you will lose the second and any subsequent lines, its a bit like merging the cells, you will lose the second line;
For those who are wondering what is going on I will put in a little explanation here: (Even if you don't have an immediate use for this one, it's one of those handy little pieces of information that may just get you out of a jam one day. :-)

For example your Excel file has both first and last names in the same cell?
Now how are you supposed to sort that list alphabetically by last name when first name is listed first?
The answer is that you can't