| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Seperate Names on Columns
I have column that contain names both first and last name. I want to break
this to different column that will seperate First name on its own column and last name on another column without re-typing them. For example A A1 NAMES A2 Adanni, KIm A3 Adams, Luke A4 Angela, Murphy. Now I WANT A B First Name Last name Adanni Kim Adams Luke Angela Murphy This is a very long list names. Too much to retype them. I want to just seperate automatic |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Seperate Names on Columns
Select the entire column and go to data/text to columns. Choose delimited,
and make comma your delimiter. Sam "Kanmi" wrote: I have column that contain names both first and last name. I want to break this to different column that will seperate First name on its own column and last name on another column without re-typing them. For example A A1 NAMES A2 Adanni, KIm A3 Adams, Luke A4 Angela, Murphy. Now I WANT A B First Name Last name Adanni Kim Adams Luke Angela Murphy This is a very long list names. Too much to retype them. I want to just seperate automatic |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Seperate Names on Columns
Hi,
Highlight the column, go to Text to columns, delimiters, choose comma, next next "Kanmi" wrote: I have column that contain names both first and last name. I want to break this to different column that will seperate First name on its own column and last name on another column without re-typing them. For example A A1 NAMES A2 Adanni, KIm A3 Adams, Luke A4 Angela, Murphy. Now I WANT A B First Name Last name Adanni Kim Adams Luke Angela Murphy This is a very long list names. Too much to retype them. I want to just seperate automatic |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Seperate Names on Columns
DataText to ColumnsDelimiterComma...
-- If this post helps click Yes --------------- Jacob Skaria "Kanmi" wrote: I have column that contain names both first and last name. I want to break this to different column that will seperate First name on its own column and last name on another column without re-typing them. For example A A1 NAMES A2 Adanni, KIm A3 Adams, Luke A4 Angela, Murphy. Now I WANT A B First Name Last name Adanni Kim Adams Luke Angela Murphy This is a very long list names. Too much to retype them. I want to just seperate automatic |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need surnames in a column in excel seperate from the first names | New Users to Excel | |||
| How do I seperate a full name field out into three seperate columns? | Excel Worksheet Functions | |||
| seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
| Run macro to find names on seperate workbook, then add info from t | Excel Discussion (Misc queries) | |||
| how to seperate into columns? | Excel Worksheet Functions | |||
Hybrid Mode
