Check out,
<Data <Text To Columns
To separate the names into separate columns, and then, if you wish, you can
concatenate them back into a single column.

Post back with further questions.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"josie" wrote in message
...
how do I reverse an entire column of names that have the last name first,
first name and then middle name or initial .....in an excel workbook?
Thanks!