Can you please have a short look on the attached file, basically if somebody is familiar its a download from SAP, where items have stock on different storage locations, but being in a single field.
The pattern of it is always
1) text "SLOC"
2) number of the SLOC and ":"
So for example the cell "SLOC4:-2.947, SLOC3:201.121, SLOC1:3.414" means that item has minus 2.947 stock on SLOC4, stock 201.121 but on SLOC3, and 3.414 on SLOC1.
Could you advise whether with VBA or formula, is it possible to write some logic which would result as I did manually the C-D-E-F columns? So cutting the stock numbers out and putting under the certain SLOC column.
I assume rather it is complex but maybe someone has idea