ExcelBanter - separating items in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - separating items in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/41069-separating-items-cell.html)

Jenn

separating items in a cell

Hi. I have a column that has values like the following:
"Doe, John H."
What I want to do is put "Doe" in Column A and "John H." in column B and
lose the comma. I am sure there is an easy way to do this. Any help would be
appreciated!
TIA!

DaveB

Follow these steps:

1. Go Data-'Text to Columns'
2. Choose 'Delimited'
3. Check 'Comma'
--
Regards,

Dave

"Jenn" wrote:

Hi. I have a column that has values like the following:
"Doe, John H."
What I want to do is put "Doe" in Column A and "John H." in column B and
lose the comma. I am sure there is an easy way to do this. Any help would be
appreciated!
TIA!

All times are GMT +1. The time now is 08:53 PM.