I'm using the
SPLIT function to divide text around white spaces (" ") in strings. However, the output is inconsistent when a number is immediately followed by a period.
Column A below contains strings, and column B the function
=SPLIT(A1," ") copied down:
Note how cell B1 does not contain a period after "2015". Is this a bug?
In the meantime, I'm using the following regular expression as a workaround:
However, is there a way to account for any number of white spaces in a string?
PS: I posted this in the Google Product Forum, and I'll be sure to update either thread if progress is made!