I am trying to merge mailing spreadsheets, and the one I am building has
first name & last name columns, but my issue is that many of the other
spreadsheets have only one column for a name (smith, bob). Is there a way to
create a method to use the comma in between the "smith, bob" to separate the
data into 2 columns?

To get smith use =LEFT(C6,FIND(",",C6)-1)
and to get bob use =RIGHT(C6,FIND(",",C6)-3)

assuming C6 has smith, bob

"Zack" wrote:

I am trying to merge mailing spreadsheets, and the one I am building has
first name & last name columns, but my issue is that many of the other
spreadsheets have only one column for a name (smith, bob). Is there a way to
create a method to use the comma in between the "smith, bob" to separate the
data into 2 columns?

DataText to ColumnsComma delimited


Gord Dibben MS Excel MVP

On Thu, 21 Aug 2008 10:33:00 -0700, Zack
wrote:

I am trying to merge mailing spreadsheets, and the one I am building has
first name & last name columns, but my issue is that many of the other
spreadsheets have only one column for a name (smith, bob). Is there a way to
create a method to use the comma in between the "smith, bob" to separate the
data into 2 columns?

Data, Text to Columns/ Delimited/ Comma
--
David Biddulph

"Zack" wrote in message
...
I am trying to merge mailing spreadsheets, and the one I am building has
first name & last name columns, but my issue is that many of the other
spreadsheets have only one column for a name (smith, bob). Is there a way
to
create a method to use the comma in between the "smith, bob" to separate
the
data into 2 columns?

The last name worked, but I still can not get the first name column to
generate. Here is an example of the cell I am working with:
AARON, JERRY L.

"Sheeloo" wrote:

To get smith use =LEFT(C6,FIND(",",C6)-1)
and to get bob use =RIGHT(C6,FIND(",",C6)-3)

assuming C6 has smith, bob

"Zack" wrote:

I am trying to merge mailing spreadsheets, and the one I am building has
first name & last name columns, but my issue is that many of the other
spreadsheets have only one column for a name (smith, bob). Is there a way to
create a method to use the comma in between the "smith, bob" to separate the
data into 2 columns?

I think the answer intended may have been something like
=RIGHT(C6,LEN(C6)-FIND(",",C6)-1)
--
David Biddulph

"Zack" wrote in message
...
The last name worked, but I still can not get the first name column to
generate. Here is an example of the cell I am working with:
AARON, JERRY L.

"Sheeloo" wrote:

To get smith use =LEFT(C6,FIND(",",C6)-1)
and to get bob use =RIGHT(C6,FIND(",",C6)-3)

assuming C6 has smith, bob

"Zack" wrote:

I am trying to merge mailing spreadsheets, and the one I am building
has
first name & last name columns, but my issue is that many of the other
spreadsheets have only one column for a name (smith, bob). Is there a
way to
create a method to use the comma in between the "smith, bob" to
separate the
data into 2 columns?

Thanks David,

Yes, that was the intent.

DataText to ColumnsComma delimited
is a better solution.

"Gord Dibben" wrote:

DataText to ColumnsComma delimited


Gord Dibben MS Excel MVP

On Thu, 21 Aug 2008 10:33:00 -0700, Zack
wrote:

I am trying to merge mailing spreadsheets, and the one I am building has
first name & last name columns, but my issue is that many of the other
spreadsheets have only one column for a name (smith, bob). Is there a way to
create a method to use the comma in between the "smith, bob" to separate the
data into 2 columns?