How to use more than one "other" delimiter in excel

G

Guest

What shall I do if I have more than one type of "other" delimiters? For
example, both ">" and "#"? Seems only one character is allowed in the import
txt wizard
 
G

Guest

You can only have one delimiter. Maybe you could pull the file into notepad
and change all the # to > so there's only one.
 
D

Dave Peterson

Or select the range and do Edit|Replace to change one of the delimiters to the
other.
 

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

point as delimiter 1
Importing text with text qualifier 2
Re-use Excel macro 2
Setting The Delimiter Character for a .Csv file with Excel 4
How to create a bubble chart with more than 2 variables 0
Text to Columns Question 3
Use of multiple-character delimiters under Text To Columns 3
Unicode text and carriage returns 4

Top