Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting full name into 2 columns by first name and last name
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting full name into 2 columns by first name and last name
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting full name into 2 columns by first name and last name
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I seperate a full name field out into three seperate columns? | Excel Worksheet Functions | |||
help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
Sorting on columns | Excel Worksheet Functions | |||
SumIF full columns, multiple conditions | Excel Discussion (Misc queries) | |||
Sorting columns | Excel Worksheet Functions |