Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I separate first and last names into two columns?
I have received a data base with members' names. Unfortunately the list has
the first and last name in one column. I will be adding names and sorting names in alphabetical order. How do I separate the first and last name so that I have two distinct columns -- one for the first name and one for the last name? Thanks for your assistance in this matter. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I separate first and last names into two columns?
Look at DataText To Columns, with a separator of space or comma, depending
upon the original data. -- HTH Bob "mllasalle" wrote in message ... I have received a data base with members' names. Unfortunately the list has the first and last name in one column. I will be adding names and sorting names in alphabetical order. How do I separate the first and last name so that I have two distinct columns -- one for the first name and one for the last name? Thanks for your assistance in this matter. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I separate first and last names into two columns?
hi
an example of your data would have been nice but.... lets say we have Bart Simpson in a2 in B2 enter... =LEFT(A2,FIND(" ",A2,1)) in C2 enter..... =MID(A2,FIND(" ",A2,1)+1,99) regards FSt1 "mllasalle" wrote: I have received a data base with members' names. Unfortunately the list has the first and last name in one column. I will be adding names and sorting names in alphabetical order. How do I separate the first and last name so that I have two distinct columns -- one for the first name and one for the last name? Thanks for your assistance in this matter. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I separate last, first names from 1 column into 2 columns? | Excel Discussion (Misc queries) | |||
Separate names into columns | Excel Worksheet Functions | |||
Need Excel formula to separate names into columns, with exceptions | Excel Discussion (Misc queries) | |||
I wish to separate city, state, and zip into 3 separate columns | Excel Worksheet Functions | |||
Separate names into 2 columns? | Excel Discussion (Misc queries) |