SPLIT function in Google Spreadsheets with OR statement

Question

I want to use the split function, but with different delimiters. I thought of something like this: =SPLIT(A:A;OR("-","&")) but it doesn't work.

Is it possible to have Boolean statements within a SPLIT function?

parkydr · Accepted Answer · 2013-01-27 16:26:42Z

up vote 2 down vote accepted

The help says:

SPLIT(string, delimiter, treat_delimiters_individually)

so for text in A1 the function is

=SPLIT(A1,"-&",true)

answered Jan 27 at 16:26

parkydr
166115

Thanks, that did the job perfectly!! – Jacob Jan Tuinstra Jan 27 at 16:57

1 Answer