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 |
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) |