transferring data from external software

  • Thread starter Thread starter Eyal Semo
  • Start date Start date
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
 
I have found the answer:
Data>Text to Columns>Delimited by "comma"
Excel remembers the last use of it (Y?)
eyal
 
Back
Top