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

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

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

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

"vacaut" wrote:

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

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

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

dlw wrote:

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

"vacaut" wrote:

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

--

Dave Peterson