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

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

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

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

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