How do I separate first and last names into two columns?
in [General]
|
From: mllasalle on 3 May 2010 16:45 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.
From: Bob Phillips on 3 May 2010 16:51 Look at Data>Text To Columns, with a separator of space or comma, depending upon the original data. -- HTH Bob "mllasalle" <mllasalle(a)discussions.microsoft.com> wrote in message news:9E033A9F-CAF9-4A32-AEBA-5964013FD64F(a)microsoft.com... >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.
From: FSt1 on 3 May 2010 17:21 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.
|
Pages: 1 Prev: Time Values As Numbers Next: MSN Stock Quotes add-in for excel |