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!