Hey all,
I get several reports with information condensed into cells. When i copy it into my sheet all of the data is in one cell. I have created formulas to break the data up into different cells but one piece of data is just getting me stumped.
Cell I2 has 2 pieces of date formatted as "184/28". 184 is a flight number, 28 is the day of the month. 12/28/17". There are also flights for the following day "117/29"
I need to break up this data as follows G2=184/28 , H2=184, I2=12/28/17.
Any help with this would be appreciated.
I get several reports with information condensed into cells. When i copy it into my sheet all of the data is in one cell. I have created formulas to break the data up into different cells but one piece of data is just getting me stumped.
Cell I2 has 2 pieces of date formatted as "184/28". 184 is a flight number, 28 is the day of the month. 12/28/17". There are also flights for the following day "117/29"
I need to break up this data as follows G2=184/28 , H2=184, I2=12/28/17.
Any help with this would be appreciated.