Select column A and then datatext to columns and use the space as the
delimiter. Then sort as required
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"CT Man" wrote:

How do I take a full name in column a and have it sort into first name and
last name and have it place the first name in column a and last name into a
new column b?