Splitting cells removes additional columns

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.

Hi and welcome

Difficult to say for sure without seeing a sample workbook (always easier to help if we can see the issue in context!), but perhaps there are extra characters at the end of your strings in column A that are "spilling" over into D-F?

You could always use formulas to extract the first / last names out too...

BSB