Parsing with more than one symbol

  • Thread starter Thread starter Gee...
  • Start date Start date
G

Gee...

I have a big ole bunch of data (domain names) that I need
parsed out. What I'd like to use is // as the
delimiter...not just /, but //. Can I do that or is Excel
set up for just the single delimiter?
Thank you in advance for your help.
Gee...
 
Gee,

Excel uses single character delimiters. You could do a replace of // with
some other character that doesn't occur in your domain names, then use that
as the delimiter.

HTH,
Bernie
MS Excel MVP
 
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

Replace hard return with a delimiter? 3
Parsing Question 7
Excel Concatenate Form Name to Parse for function 1
Parsing a string 10
parse cell and insert rows? 3
Parsing formatted data 6
Prevent Auto Parse 1
Parse string 3

Back
Top