Multiple Delimiters

  • Thread starter Thread starter hassanq23
  • Start date Start date
H

hassanq23

hi ,

Is there any way i can get excel to accept multiple delimiters when
importing from a text file to an excel worksheet?

Thanks,
Hassan
 
What all are you trying to use? By just using the check boxes, you can use
commas, semicolons, tab, space, and 1 other symbol/character of your choice.
 
Yes, just click on more than one check box when specifying delimiters in the
text import wizard.

Regards,
Fred.
 
You should be prompted on the wizard that allows multiple delimiters. But you
only get one "other" delimeter.

When I have this kind of thing, I'll either edit the text file and change all
the other delimiters to a single common delimiter.

Or I'll bring in the text file into a single column and do the change in excel.
Then use data|text to columns to parse the data.
 
hi,

Basically i am trying to import a file which seperates the data with '|' and
space...so i needed to see if i can specify blank space as well as '|' as a
delimiter.

Thanks for your help :)

Hassan
 
Check the box for Space
Check the box for Other
Enter "|" in the box beside Other.

Regards,
Fred.
 

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

Text to columns 2
point as delimiter 1
Import Delimited File 1
Columns formatted As Dates Are Exported as a Number to Text 1
Drag text file to Excel -- stopped working 5
tab delimited characters 1
Excel 2003 inserts quotes when saving SS as text and comma is pres 1
Paste comma delimited text into a spread sheet 5

Back
Top