Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Separating information in cell
I am using Excel 2003 SP2. I receive reports with first and last names
together in one cell: Jones,Edward Smith, David Longview,Samantha Is there a way to move the first name to the same row in the next column, then remove the comma following the last name? -- Cynthia |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Separating information in cell
With your names in column A, make sure column B is empty so it will accept
the first names. Select the range of cells in column A that contain the names Goto the menu DataText to Columns Select DelimitedNext Select CommaFinish This will move the first names and remove the commas at the same time. -- Biff Microsoft Excel MVP "Cynthia" wrote in message ... I am using Excel 2003 SP2. I receive reports with first and last names together in one cell: Jones,Edward Smith, David Longview,Samantha Is there a way to move the first name to the same row in the next column, then remove the comma following the last name? -- Cynthia |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Separating information in cell
Chip has lots to help you at
http://www.cpearson.com/excel/FirstLast.htm for more examples do a Google with search term: Excel last name first name. I got nearly 2 million hits Hope you do not think this a lazy answer but why reinvent the wheel? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Cynthia" wrote in message ... I am using Excel 2003 SP2. I receive reports with first and last names together in one cell: Jones,Edward Smith, David Longview,Samantha Is there a way to move the first name to the same row in the next column, then remove the comma following the last name? -- Cynthia |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Separating information in cell
Oh, joy - hurray for easy solutions - thank you!!
-- Cynthia "T. Valko" wrote: With your names in column A, make sure column B is empty so it will accept the first names. Select the range of cells in column A that contain the names Goto the menu DataText to Columns Select DelimitedNext Select CommaFinish This will move the first names and remove the commas at the same time. -- Biff Microsoft Excel MVP "Cynthia" wrote in message ... I am using Excel 2003 SP2. I receive reports with first and last names together in one cell: Jones,Edward Smith, David Longview,Samantha Is there a way to move the first name to the same row in the next column, then remove the comma following the last name? -- Cynthia |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Separating information in cell
Wonderful - thank you! Sometimes I really do love the Internet...
-- Cynthia "Bernard Liengme" wrote: Chip has lots to help you at http://www.cpearson.com/excel/FirstLast.htm for more examples do a Google with search term: Excel last name first name. I got nearly 2 million hits Hope you do not think this a lazy answer but why reinvent the wheel? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Cynthia" wrote in message ... I am using Excel 2003 SP2. I receive reports with first and last names together in one cell: Jones,Edward Smith, David Longview,Samantha Is there a way to move the first name to the same row in the next column, then remove the comma following the last name? -- Cynthia |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Separating information in cell
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Cynthia" wrote in message ... Oh, joy - hurray for easy solutions - thank you!! -- Cynthia "T. Valko" wrote: With your names in column A, make sure column B is empty so it will accept the first names. Select the range of cells in column A that contain the names Goto the menu DataText to Columns Select DelimitedNext Select CommaFinish This will move the first names and remove the commas at the same time. -- Biff Microsoft Excel MVP "Cynthia" wrote in message ... I am using Excel 2003 SP2. I receive reports with first and last names together in one cell: Jones,Edward Smith, David Longview,Samantha Is there a way to move the first name to the same row in the next column, then remove the comma following the last name? -- Cynthia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separating Names in a cell | Excel Discussion (Misc queries) | |||
Separating information in one cell into several cells | Excel Discussion (Misc queries) | |||
Separating names from one cell | Excel Discussion (Misc queries) | |||
Separating data in a cell | Excel Discussion (Misc queries) | |||
How to separating first and last name (in a single cell... | Excel Discussion (Misc queries) |