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