splitting the values from one column into two
 

I have spreadsheet that has a column for names. The names have been input as
follows: lastname, firstname". Is there a way to copy the first name to a
new column and the last name to a different column?
--
Elise King-Lynch

DataText to Columns and choose a delimiter of comma

--
HTH

Bob Phillips

"Elise" wrote in message
...
I have spreadsheet that has a column for names. The names have been input
as
follows: lastname, firstname". Is there a way to copy the first name to a
new column and the last name to a different column?
--
Elise King-Lynch

Data menu,
Text to columns command

It will handle delimited or fixed width data in one column to several

"Elise" wrote:

I have spreadsheet that has a column for names. The names have been input as
follows: lastname, firstname". Is there a way to copy the first name to a
new column and the last name to a different column?
--
Elise King-Lynch

Data - Text to Columns, delimited, use comma as the separater. HTH
--
Sincerely, Michael Colvin


"Elise" wrote:

I have spreadsheet that has a column for names. The names have been input as
follows: lastname, firstname". Is there a way to copy the first name to a
new column and the last name to a different column?
--
Elise King-Lynch

Do a "Text to Column" under "Data". Be sure to insert an extra column before
you split your text first.

"Elise" wrote:

I have spreadsheet that has a column for names. The names have been input as
follows: lastname, firstname". Is there a way to copy the first name to a
new column and the last name to a different column?
--
Elise King-Lynch

There are probably some names that would need to be altered manually but
using your eaxample

=LEFT(A1,find(",",A1)-1)

for the last name, assum you put this in B1, then for first name in C1

=TRIM(SUBSTITUTE(A1,B1&",",""))

or you can make sure the next column to the right is empty, then do
datatext to columns, delimited, select comma and click finish

That will basically split the columns into 2

Also when you are done with the formulas, copy them, then do editpaste
special as values in place to make them independent of the name column

Regards,

Peo Sjoblom

"Elise" wrote:

I have spreadsheet that has a column for names. The names have been input as
follows: lastname, firstname". Is there a way to copy the first name to a
new column and the last name to a different column?
--
Elise King-Lynch

Thanks so much.
--
Elise King-Lynch


"TomHinkle" wrote:

Data menu,
Text to columns command

It will handle delimited or fixed width data in one column to several

"Elise" wrote:

I have spreadsheet that has a column for names. The names have been input as
follows: lastname, firstname". Is there a way to copy the first name to a
new column and the last name to a different column?
--
Elise King-Lynch