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?
