New Contributor

# Excel Formulas, help!

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

# Re: Excel Formulas, help!

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

# Re: Excel Formulas, help!

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

# Re: Excel Formulas, help!

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.