Separate data on different columns

Occasional Visitor

I currently have a data base with raw data that contains SS numbers, names and appointment dates. How ever, its transferred from another program which populates all data in the same column. I've been looking for a way, possible using JavaScript to separate some of that data into different columns but I've had no success. Every entry has an initial ID at the beginning which makes using length related formulas a bit complicates I think.


Here is an example of my raw data and what im trying to accomplish. Any help would be truly appreciated.






9 5555 Doe-John 09/17/2022 @ 9:00 Future




10 6666 Mead-Erick 09/17/2022 @ 10:00 Future

11 7777 Davis-Matt 09/17/22 @13:00 Future7777Davis-Matt13:00


As you can see, I don't need all of the raw data. Only SS,NAMES and TIME. 

Thanks in advance!

2 Replies


You can use Flash Fill.


Select the data in column A.

On the Data tab of the ribbon, click Text to Columns.

Select Delimited, then click Next >.

Tick the check box for Space.

Also tick the check box for Other, and enter @ in the box next to it.


Click Next >.

One by one. select the columns you don't need, and select 'Do not import column (skip)'.

Specify the cell next to the first raw data cell as destination ($B$2 in the screenshot).


Finally, click Finish.