I have a customer list of 20,000 people and businesses in the same collumn. I have managed to sort out the first names into another column with the text to collumns function because the names were sorted by a ",". I am trying to move the business names into another collumn based on there being a " " in the cell. So I have one cell with:
John
and another cell with:
Quailty air

I am trying to move all cells that contain a " " (space) to the adjacent cell. Again theis collumn is 20,000 records longI am just looking for a cimple formula to copy down to accomplish this.

Can anyone help with this?

Thanks for your help