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.

 

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

6666Mead-Erick10:00
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

@Humboldt33 

You can use Flash Fill.

@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.

S1746.png

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).

S1748.png

Finally, click Finish.