Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
How do you convert numbers as "text" to values for a long column . | Excel Discussion (Misc queries) | |||
Move column values w/o formula | Excel Worksheet Functions | |||
Finding the max of a column where values less than a specified number | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |