| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for separating data into two columns
I have a list of over 15,000 names in one column and I need a formula to
separate the surnames into one column and the first names into a second column. I've done this before but have forgotten the formula. Can anyone help me? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for separating data into two columns
hi
that would depend on the layout. it could involve using the "LEFT", "RIGHT", and/or "MID" functons and may include other functions. Post an 10 item example of your data. regards FSt1 "Lacey1941" wrote: I have a list of over 15,000 names in one column and I need a formula to separate the surnames into one column and the first names into a second column. I've done this before but have forgotten the formula. Can anyone help me? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for separating data into two columns
AAEN, BARBARA JEAN
AARON, ELCIE L ABDALLAH, MOHAMED AHMED ABE, KATASHIGE ABE, KENJI ABE, MORIMATSU ABE, SHIGEKO ABERNATHY, LIONEL ABLES, LONNIE ABNEY, DONALD MAX All names are in the A column now and I want to leave the surname in the A column and move the given name into the (B) column. "FSt1" wrote: hi that would depend on the layout. it could involve using the "LEFT", "RIGHT", and/or "MID" functons and may include other functions. Post an 10 item example of your data. regards FSt1 "Lacey1941" wrote: I have a list of over 15,000 names in one column and I need a formula to separate the surnames into one column and the first names into a second column. I've done this before but have forgotten the formula. Can anyone help me? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for separating data into two columns
Data Text to Columns Next select Comma Finish
"Lacey1941" wrote: AAEN, BARBARA JEAN AARON, ELCIE L ABDALLAH, MOHAMED AHMED ABE, KATASHIGE ABE, KENJI ABE, MORIMATSU ABE, SHIGEKO ABERNATHY, LIONEL ABLES, LONNIE ABNEY, DONALD MAX All names are in the A column now and I want to leave the surname in the A column and move the given name into the (B) column. "FSt1" wrote: hi that would depend on the layout. it could involve using the "LEFT", "RIGHT", and/or "MID" functons and may include other functions. Post an 10 item example of your data. regards FSt1 "Lacey1941" wrote: I have a list of over 15,000 names in one column and I need a formula to separate the surnames into one column and the first names into a second column. I've done this before but have forgotten the formula. Can anyone help me? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for separating data into two columns
I'm sorry but I still don't have any idea how to set up the formula.
"Teethless mama" wrote: Data Text to Columns Next select Comma Finish "Lacey1941" wrote: AAEN, BARBARA JEAN AARON, ELCIE L ABDALLAH, MOHAMED AHMED ABE, KATASHIGE ABE, KENJI ABE, MORIMATSU ABE, SHIGEKO ABERNATHY, LIONEL ABLES, LONNIE ABNEY, DONALD MAX All names are in the A column now and I want to leave the surname in the A column and move the given name into the (B) column. "FSt1" wrote: hi that would depend on the layout. it could involve using the "LEFT", "RIGHT", and/or "MID" functons and may include other functions. Post an 10 item example of your data. regards FSt1 "Lacey1941" wrote: I have a list of over 15,000 names in one column and I need a formula to separate the surnames into one column and the first names into a second column. I've done this before but have forgotten the formula. Can anyone help me? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for separating data into two columns
It's not a formula, first make sure you have at least 2 empty column to the
right of your column, then select the whole column and do datatext to columns, select delimited, click next and select comma as delimiter and click finish. Then make sure it worked and finally save the work after you made sure it worked OK. -- Regards, Peo Sjoblom "Lacey1941" wrote in message ... I'm sorry but I still don't have any idea how to set up the formula. "Teethless mama" wrote: Data Text to Columns Next select Comma Finish "Lacey1941" wrote: AAEN, BARBARA JEAN AARON, ELCIE L ABDALLAH, MOHAMED AHMED ABE, KATASHIGE ABE, KENJI ABE, MORIMATSU ABE, SHIGEKO ABERNATHY, LIONEL ABLES, LONNIE ABNEY, DONALD MAX All names are in the A column now and I want to leave the surname in the A column and move the given name into the (B) column. "FSt1" wrote: hi that would depend on the layout. it could involve using the "LEFT", "RIGHT", and/or "MID" functons and may include other functions. Post an 10 item example of your data. regards FSt1 "Lacey1941" wrote: I have a list of over 15,000 names in one column and I need a formula to separate the surnames into one column and the first names into a second column. I've done this before but have forgotten the formula. Can anyone help me? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for separating data into two columns
Thanks so much.......it works great.
"Peo Sjoblom" wrote: It's not a formula, first make sure you have at least 2 empty column to the right of your column, then select the whole column and do datatext to columns, select delimited, click next and select comma as delimiter and click finish. Then make sure it worked and finally save the work after you made sure it worked OK. -- Regards, Peo Sjoblom "Lacey1941" wrote in message ... I'm sorry but I still don't have any idea how to set up the formula. "Teethless mama" wrote: Data Text to Columns Next select Comma Finish "Lacey1941" wrote: AAEN, BARBARA JEAN AARON, ELCIE L ABDALLAH, MOHAMED AHMED ABE, KATASHIGE ABE, KENJI ABE, MORIMATSU ABE, SHIGEKO ABERNATHY, LIONEL ABLES, LONNIE ABNEY, DONALD MAX All names are in the A column now and I want to leave the surname in the A column and move the given name into the (B) column. "FSt1" wrote: hi that would depend on the layout. it could involve using the "LEFT", "RIGHT", and/or "MID" functons and may include other functions. Post an 10 item example of your data. regards FSt1 "Lacey1941" wrote: I have a list of over 15,000 names in one column and I need a formula to separate the surnames into one column and the first names into a second column. I've done this before but have forgotten the formula. Can anyone help me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Emulating Text to Columns -- Separating Data into Appropriate Colu | Excel Worksheet Functions | |||
| separating data in columns | Excel Worksheet Functions | |||
| separating data into multiple columns | New Users to Excel | |||
| Separating Data Into Multiple Columns | Excel Discussion (Misc queries) | |||
| Separating a name into first name and last name columns | Excel Discussion (Misc queries) | |||
Linear Mode
