Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting Last Name, First Name
I have a field with Last name separated by a comma and then First Name (ie
Smith, John). The names are not the same length and comma is not at same place (if so, text to colum would work). Is there a way to split field to get last name in one colum and first name in another colum? thanks Sal |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting Last Name, First Name
With your data beginning in A1
In B1 enter In C1 enter =LEFT(A1,FIND(",",A1)-1) =RIGHT(A1,(LEN(A1)-FIND(",",A1)-1)) and copy down "buggles" wrote: I have a field with Last name separated by a comma and then First Name (ie Smith, John). The names are not the same length and comma is not at same place (if so, text to colum would work). Is there a way to split field to get last name in one colum and first name in another colum? thanks Sal |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting Last Name, First Name
"Jim May" wrote: With your data beginning in A1 In B1 enter In C1 enter =LEFT(A1,FIND(",",A1)-1) =RIGHT(A1,(LEN(A1)-FIND(",",A1)-1)) and copy down "buggles" wrote: I have a field with Last name separated by a comma and then First Name (ie Smith, John). The names are not the same length and comma is not at same place (if so, text to colum would work). Is there a way to split field to get last name in one colum and first name in another colum? thanks Sal thanks, much JIM!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting Last Name, First Name
'The names are not the same length and comma is not at same
place (if so, text to colum would work).' Text to column will work, use the delimited option and select the comma as the delimiter, Regards, Alan. "buggles" wrote in message ... "Jim May" wrote: With your data beginning in A1 In B1 enter In C1 enter =LEFT(A1,FIND(",",A1)-1) =RIGHT(A1,(LEN(A1)-FIND(",",A1)-1)) and copy down "buggles" wrote: I have a field with Last name separated by a comma and then First Name (ie Smith, John). The names are not the same length and comma is not at same place (if so, text to colum would work). Is there a way to split field to get last name in one colum and first name in another colum? thanks Sal thanks, much JIM!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting Last Name, First Name
Jim, worked like a charm!!! thank you VERY much!! "Jim May" wrote: With your data beginning in A1 In B1 enter In C1 enter =LEFT(A1,FIND(",",A1)-1) =RIGHT(A1,(LEN(A1)-FIND(",",A1)-1)) and copy down "buggles" wrote: I have a field with Last name separated by a comma and then First Name (ie Smith, John). The names are not the same length and comma is not at same place (if so, text to colum would work). Is there a way to split field to get last name in one colum and first name in another colum? thanks Sal |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
splitting a cell | Excel Discussion (Misc queries) | |||
Splitting names | Excel Discussion (Misc queries) | |||
Splitting Panes | Excel Discussion (Misc queries) | |||
Splitting one column into two | New Users to Excel | |||
Splitting Cells | Excel Discussion (Misc queries) |