Excel Help..!!

[Columbo]

Below is a set of data exported from our WMS.

Is there a way I can insert a column or extract the data between LOC: & LPN: as it exports them all in them same cell.

Any help appreciated.

 

[Columbo]

Got it sorted cheers guys by using the text import wizard.

I replaced the LOC: and LPN: with a comma and and saved it as a text file, then imported it and delimited it by , and it inserted a column.

Thanks for the help..!!