THANK YOU SO MUCH, THIS WAS A LIFE SAVER!! I KNEW THERE HAD TO BE A WAY,
EXCEL CAN DO A N Y T H I N G !! Thanks all for your assistance, I'm telling
my friends about this website. Again, you're a life saver. MERRY CHRISTMAS!!

"Ron Coderre" wrote:

See if this works for you...
Try DataText-to-Columns
Set the delimiters to comma and space

That should break the text into 2 columns.

Does that help?

***********
Regards,
Ron


"RenieFo" wrote:

ANYONE KNOW, OTHER THAN CUT AND PASTE, A METHOD OF "flip flopping" names in a
list, from last, first to first last? (maybe "telling"the list to separate
into 2 columns the words separated by the comma, last in one column and first
in another). I have a list of 360 names and not looking forward to cut and
paste this list. HELP!