Breaking down the nuances of =TEXTSPLIT(), turning bulky text into manageable pieces.
Note that if there are spaces adjacent to your delimiter, you should include them in the delimiter. Otherwise, the spaces are left in the output text.
TEXTSPLIT("Mary, Bill, Pete", ",") with no space in the delimiter "," results in {"Mary", " Bill", " Pete"} with spaces before " Bill" and " Pete".
TEXTSPLIT("Mary, Bill, Pete", ", ") with a space in the delimiter ", " results in {"Mary", "Bill", "Pete"} with no spaces.
Thanks Jon! I think I mentioned using =TRIM() as a way to alleviate this issue as well.
Perhaps you mentioned TRIM(), and I thought of it. But using the precise definition of the delimiter is probably most efficient.
Thanks Michael! I just put out a newsletter on the TAKE function.
Note that if there are spaces adjacent to your delimiter, you should include them in the delimiter. Otherwise, the spaces are left in the output text.
TEXTSPLIT("Mary, Bill, Pete", ",") with no space in the delimiter "," results in {"Mary", " Bill", " Pete"} with spaces before " Bill" and " Pete".
TEXTSPLIT("Mary, Bill, Pete", ", ") with a space in the delimiter ", " results in {"Mary", "Bill", "Pete"} with no spaces.
Thanks Jon! I think I mentioned using =TRIM() as a way to alleviate this issue as well.
Perhaps you mentioned TRIM(), and I thought of it. But using the precise definition of the delimiter is probably most efficient.
Thanks Michael! I just put out a newsletter on the TAKE function.