| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separate names into 2 columns?
I have a column of names (first & last name). Is it possible to separate them into two columns - 1 column for first name, next column for last name? Thanx...JF -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=490866 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separate names into 2 columns?
Yes.
Use the Menu Data-- Text to columns wizard.... And voila! "Ltat42a" escribió en el mensaje ... I have a column of names (first & last name). Is it possible to separate them into two columns - 1 column for first name, next column for last name? Thanx...JF -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=490866 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separate names into 2 columns?
I don't know if it is appropriate to bogart onto someone else's post but is
it possible to do this in reverse. That is take first and last name or First name, spouse first name and Last name information from separate columns and combine it into one column ie John & Jane Smith or John Smith "Hernandez, Roberto" wrote: Yes. Use the Menu Data-- Text to columns wizard.... And voila! "Ltat42a" escribió en el mensaje ... I have a column of names (first & last name). Is it possible to separate them into two columns - 1 column for first name, next column for last name? Thanx...JF -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=490866 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separate names into 2 columns?
John in A1
Jane in B1 Smith in C1 In D1 enter =A1 & " & " & B1 & " " & C1 Returns John & Jane Smith Gord Dibben Excel MVP On Tue, 6 Dec 2005 12:16:03 -0800, "Ineluctable" wrote: I don't know if it is appropriate to bogart onto someone else's post but is it possible to do this in reverse. That is take first and last name or First name, spouse first name and Last name information from separate columns and combine it into one column ie John & Jane Smith or John Smith "Hernandez, Roberto" wrote: Yes. Use the Menu Data-- Text to columns wizard.... And voila! "Ltat42a" escribió en el mensaje ... I have a column of names (first & last name). Is it possible to separate them into two columns - 1 column for first name, next column for last name? Thanx...JF -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=490866 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separate names into 2 columns?
Add in an IF statement and it works like a charm all in one column.
Thanks "Gord Dibben" wrote: John in A1 Jane in B1 Smith in C1 In D1 enter =A1 & " & " & B1 & " " & C1 Returns John & Jane Smith Gord Dibben Excel MVP On Tue, 6 Dec 2005 12:16:03 -0800, "Ineluctable" wrote: I don't know if it is appropriate to bogart onto someone else's post but is it possible to do this in reverse. That is take first and last name or First name, spouse first name and Last name information from separate columns and combine it into one column ie John & Jane Smith or John Smith "Hernandez, Roberto" wrote: Yes. Use the Menu Data-- Text to columns wizard.... And voila! "Ltat42a" escribió en el mensaje ... I have a column of names (first & last name). Is it possible to separate them into two columns - 1 column for first name, next column for last name? Thanx...JF -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=490866 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separate names into 2 columns?
?????
Gord On Tue, 6 Dec 2005 13:56:04 -0800, "Ineluctable" wrote: Add in an IF statement and it works like a charm all in one column. Thanks "Gord Dibben" wrote: John in A1 Jane in B1 Smith in C1 In D1 enter =A1 & " & " & B1 & " " & C1 Returns John & Jane Smith Gord Dibben Excel MVP On Tue, 6 Dec 2005 12:16:03 -0800, "Ineluctable" wrote: I don't know if it is appropriate to bogart onto someone else's post but is it possible to do this in reverse. That is take first and last name or First name, spouse first name and Last name information from separate columns and combine it into one column ie John & Jane Smith or John Smith "Hernandez, Roberto" wrote: Yes. Use the Menu Data-- Text to columns wizard.... And voila! "Ltat42a" escribió en el mensaje ... I have a column of names (first & last name). Is it possible to separate them into two columns - 1 column for first name, next column for last name? Thanx...JF -- Ltat42a ------------------------------------------------------------------------ Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735 View this thread: http://www.excelforum.com/showthread...hreadid=490866 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding three consecutive columns | Excel Worksheet Functions | |||
| Breaking up a string into separate columns | Excel Worksheet Functions | |||
| How do I remove duplicated information in 2 columns of Excel? | Excel Discussion (Misc queries) | |||
| How do I separate words in one cell into two cells? | Excel Worksheet Functions | |||
| Separating Names in a Column to Two Columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
