Dividing a cell

[djarcadian]

I exported our customer list from Quickbooks and it put all our customer names in one cell in the Last Name, First Name format. I would like the first and last name to each have their own cell. Is there a way to do this in Excel?

[NBVC]

If there is data in columns after this column then insert a new column after the column you want to split.

Then select the column to split and go to Data|Text to Columns and select Delimited and click Next.

Check the Space checkbox (if there is another delimiter instead of space, check the corresponding checkbox).

Click Finish.

[djarcadian]

Thanks!