Parsing with more than one symbol

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...
 
B

Bernie Deitrick

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
 

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
How to create a bubble chart with more than 2 variables. 0
Possible to Combine reports to's to a single box? 0
Parsing a string 10
Start a mail merge upon opening the document 1
Parse a Cell value using another listing showing criteria 6
Parsing imported csv data 12
Drag text file to Excel -- stopped working 5

Top