Split based on multiple criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
one way

Split(Replace(Replace(Replace(Replace(Replace(string, _
"+", "\"), "-", "\"), "/", "\"), "*", "\"), "^", "\"), "\")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Multiple Line handling with Split() 1
List found strings on sheet 34
Passing result of multiple split function results to 1 Array 5
split excel into multiple sheet 4
String to be split 4
Using Split Function on String with no spaces 7
Split an Excel file into separate files 3
Split function - assign to array 2

Back
Top