Split based on multiple criteria
 

I know I can use the split funciton to split a string based on an argument:

Split(string, "\")

Is it possible to split using multiple criteria? Say the multliple critera
was operators Split (sting,{(+,-,/,*^})

Thanks
EM

Split based on multiple criteria
 

one way

Split(Replace(Replace(Replace(Replace(Replace(stri ng, _
"+", "\"), "-", "\"), "/", "\"), "*", "\"), "^", "\"), "\")


In article ,
ExcelMonkey wrote:

I know I can use the split funciton to split a string based on an argument:

Split(string, "\")

Is it possible to split using multiple criteria? Say the multliple critera
was operators Split (sting,{(+,-,/,*^})

Thanks
EM