tricky text formula from several columns and merge in one columns

[JEAN1972]

I have worksheet which need to extract data starting from column K,L,M and G and insert in columns J

normal split, extract from columns K, L and from G, the word 1L resulting in J 16*4*1L

The second split type extract from column M and G and insert in J resulting to 2*6*1.5l

Third type of split extract from column K and L but criteria column H code by default and assign 75 cl.

those who are highlighted in yellow * are tricky .

Only part formula solution have been found so far

Please Login or Register  to view this content.

http://forum.chandoo.org/threads/for...2/#post-212406

[JEAN1972]

ok got the results

query solved

Please Login or Register  to view this content.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.