Help me break this down

[cesar333]

I have to pull customers flight information from a website and paste it to my sheet but when doing so it puts all of the information into 1 cell. I have tried delimiter function but its hit and miss. I have tried variations of code and formulas but its just a big mess. What i need is to be able to paste this infomation into a cell and have it split up and formatted properly into individual cells. Information is in A2
So here is my info below and below that is what i am looking to achieve;


A2-1406/30 IN 0048K180 321S 878 947/31 OFF 0843 MIA 170 LGA 2
G2-1406 (this is the flight#)
H2- /30 (this is a date 12/30/17)
I2 - IN ( this is the status of the flight)
J2 - 0048 (This is the time, **the "K" means nothing and can be remove. This is where i get stuck Format as 00:48)
K2 - 180 (means nothing)
L2 - 321S (aircraft type)
M2- 878 ( Means nothing
N2 - 947 ( Flight out number
O2 - /31 (Date= 12/31/17)
P2 - OFF - (means flight status)
Q2 - 0843 (Time out - Time Format as 08:43)
R2 MIA - (Destination - Keep as MIA)
S2 - 170 ( means nothing)
T2 - LGA - (city)
U2 - 2 (Gate Location)

Any help would be greatly appreciated.

 

[philwojo]

Seems like most of this would work with the Text-to-columns function, you could set 2 delimators, one being space the other being "/". If you can live without the slash being in H2 and O2 that should work for you.

 

[philwojo]

Sorry it won't push it to those cells, it would start in A2 and go to N2, but here is the output I get when I do that:

A

B

C

D

E

F

G

H

I

J

K

L

M

N

2

1406

30

IN

0048K180

321S

878

947

31

off

843

MIA

170

LGA

2

3

<tbody>
</tbody>