The easiest solution is to preprocess the string using the Search and Replace String Function.
The Search and Replace String Function is found in the String Functions Palette.
- Right click the Search and Replace String Function and select Regular Expression from the shortcut menu.
- Wire a string constant containing " +" to the search string input. This is a regular expression that will match one or more spaces.
- Wire a string constant containing a single space to the replace string input. This will replace each instance of multiple spaces with a single space.
We should now have a spreadsheet string that is simply space delimited, and can be read normally by the usual spreadsheet string functions.