Hi all,

Newbie here. I have a bunch of sheets with info where I need to separate the first and last names out. All easy, except that when I go through the below steps, I also lose all the data in the other cells.

I have the name in column A, then have left B and C columns open for first and last name split, then columns D- F are phone numbers, address etc.

How do I split without losing the D-F column data?

Thanks in advance

A



Select Data > Text to Columns.

In the Convert Text to Columns Wizard, select Delimited > Next.

Select the Delimiters for your data. For example, Comma and Space. You can see a preview of your data in the Data preview window.

Select Next.

Select the Destination in your worksheet which is where you want the split data to appear.

Select Finish.