Apr 23 2021 01:37 AM - edited Apr 23 2021 02:34 AM
Hello!
I wish to break down a describtion of an item into different sections of coulumbs.
As for example, lets say it's written "Computer 554x374x16 (244mm c/c)"
I would want it to be divided into "Computer", "554", "374", "16", "244mm c/c".
This would make it so much easier for me, would appreciate any help given. I'm open-minded and I can adjust the text slightly if needed. (Perhaps it's better with L554 B374 T16, rather then "x"' between.
Apr 30 2021 12:38 PM
It's better to use same delimiter, e.g. space, everywhere. With that it could be
formula is
= TRANSPOSE( FILTERXML("<root><node>"&SUBSTITUTE(A1," ","</node><node>")&"</node></root>","//node") )
May 03 2021 01:58 AM
Hello Sergei!
You're on the right track, it's something like this that I'm seeking for, much appreciated!
I can't divide it with only spaces like you suggested though, it needs to be written in a certain way. Would you mind trying to figure it out?
Computer 554x374x16mm (244mm c/c)
(Computer) (554) (374) (16) ((244mm c/c))
May 03 2021 02:42 PM
If you could use without double brackets like
(Computer) (554) (374) (16) (244mm c/c)
it could be
Or to use couple of more nested SUBSTITUTE() for them.