Separate data on different columns

[Humboldt33]

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.

RAW DATA	S.S.	Name	Appointment
9 5555 Doe-John 09/17/2022 @ 9:00 Future	5555	Doe-John	9:00
10 6666 Mead-Erick 09/17/2022 @ 10:00 Future	6666	Mead-Erick	10:00
11 7777 Davis-Matt 09/17/22 @13:00 Future	7777	Davis-Matt	13:00

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

Thanks in advance!

[#2]

@Humboldt33 

You can use Flash Fill.

[#3]

@Humboldt33 

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.