Would be great if someone could give me a formula which would separate text between 2 spaces e.g
10001031 BISCUIT TUC NATURE 100G Ea BEACH SHOP -6 Transfer material between subinventories 3435516
i.e would like to have per below in diff cells:
10001031
BISCUIT TUC NATURE 100G
Ea
BEACH SHOP
-6
Transfer material between subinventories
3435516

Looking fwd for a solution to my problem - Thxs a lot