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

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

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!!

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!!

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