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
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.
I don't understand why there's this error. Can anybody help me to fix it?