Text to Columns Formula
Posted by Tom Packert on March 30, 2001 3:07 PM
I have looked all over for a quicker way to implement a way to extract fields from a delimited string.
I have data being returned from a queries that looks like this:
I need to break these out into the Separate Values. I know I can use the TexttoColumns method in a Macro, but I was hoping there was a hidden formula that does this like the Notes @WORD() function.
The search and MID functions can be combined to do this but is gets really ugly. There has got to be a better way.
Its late and its friday so... Any help is appreciated!