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