I should have mentioned, back up before you try it, because their is no Undo!

"Chris" wrote in message ...
I have two spread sheets with names of the same people on
them with different info on each. The master workbook
has the names in a cell as a FIRST LAST format. I want
to bring data in from another workwork which has the
names listed as LAST, FIRST. is there a marco which will
go through a column and switch the order? thanks