Thread: Sorting full name into 2 columns by first name and last name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
  
Posts: 1,316
Default Sorting full name into 2 columns by first name and last name
Select the column with the first & last names and then click DATA in the menu
and select TEXT TO COLUMNS.


--
Kevin Backmann


"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?
Reply With QuoteReply With Quote