using data from ascii file?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know how to get my formulas to pull data from another workbook... but what
if I want it to pull from an ascii, comma-delimited file? Then I am not sure
if it can recognize columns/rows? Suggestions? Thanks-
 
Bring the .csv file into excel and save it as a .xls file. Then use that in
your formula.
 
thanks.. I wanted it to be automatic. I think I figured out how to do it in
IMPORT DATA. Thanks though!
 
Back
Top