transferring data from external software

E

Eyal Semo

Hello all
as regards transferring data from external software ( Priorti ) to Excel
(the data will be passed as text file, delimited by tab, notation of fields
of text by commas)
the Excel delimit the fields both by commas and the tab.
How it's possible to change default pattern of Excel so the delimeter will
be tab only
(the data are passed directly to Excel and therefore I don't have
possibility for manual import of the data
TNX, eyal semo
 
E

Eyal Semo

I have found the answer:
Data>Text to Columns>Delimited by "comma"
Excel remembers the last use of it (Y?)
eyal
 

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

Top