Assuming the full name in column A is like:

James Ravenswood

1. first name first
2. no middle initial
3. single space between first name and last name

Select colum A and:

Data Text to Columns... Delimited Next check space Finish

You will be left with james in A1 and Ravenswood in B1, etc.
--
Gary''s Student - gsnu200764


"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?