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