Excel Formulas, help!

Copper Contributor

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.

3 Replies

@MaxS95 

It's better to use same delimiter, e.g. space, everywhere. With that it could be

image.png

formula is

= TRANSPOSE( FILTERXML("<root><node>"&SUBSTITUTE(A1," ","</node><node>")&"</node></root>","//node") )

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))

@MaxS95 

If you could use without double brackets like

(Computer) (554) (374) (16) (244mm c/c)

it could be

image.png

Or to use couple of more nested SUBSTITUTE() for them.