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
|