Multiple Delimiters
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 |
Multiple Delimiters
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "hassanq23" wrote: 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 |
Multiple Delimiters
Yes, just click on more than one check box when specifying delimiters in the
text import wizard. Regards, Fred. "hassanq23" wrote in message ... 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 |
Multiple Delimiters
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. hassanq23 wrote: 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 -- Dave Peterson |
Multiple Delimiters
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 "Luke M" wrote: 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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "hassanq23" wrote: 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 |
Multiple Delimiters
Check the box for Space
Check the box for Other Enter "|" in the box beside Other. Regards, Fred. "hassanq23" wrote in message ... 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 "Luke M" wrote: 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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "hassanq23" wrote: 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 |
All times are GMT +1. The time now is 07:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com