On Sunday, June 19, 2016 at 6:43:33 AM UTC+4, ANG wrote:
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

OR PLS ALSO GIVE ME A MACRO TO DO IT