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

V

vacaut

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
 
D

dlw

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