My string is separated by an indefinite and variable number of underscores. "SOMETEXT_MORETEXT_ABCD_DEF_..." I need to put each word inside a different column. I've found these links which explain exactly what I'm trying to do.

- How to split a string based on “:” in MS-Excel?
- Split text into different columns from the right
- How To Reverse The Concatenate Function In Excel?

The formula is `=TRIM(MID(SUBSTITUTE($A2,",",REPT(" ",999)),COLUMNS($A:A)*999-998,999))`

I've used the exact same formula and changed the references and the delimiter but it doesn't work and gives me a #value error.

My file: https://app.box.com/s/q21pc0r04sqvf4ewdjw6b1cmtu6o0cnn

I don't understand why there's this error. Can anybody help me to fix it?

`STRINGA.ESTRAI`

not`MEDIA`

7more comments