ExcelBanter - using data from ascii file?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - using data from ascii file? (https://www.excelbanter.com/excel-discussion-misc-queries/61413-using-data-ascii-file.html)

NTaylor

using data from ascii file?

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-
--
Nicki Taylor

Dave Peterson

using data from ascii file?

Bring the .csv file into excel and save it as a .xls file. Then use that in
your formula.

NTaylor wrote:

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-
--
Nicki Taylor

--

Dave Peterson

NTaylor

using data from ascii file?

thanks.. I wanted it to be automatic. I think I figured out how to do it in
IMPORT DATA. Thanks though!
--
Nicki Taylor

"Dave Peterson" wrote:

Bring the .csv file into excel and save it as a .xls file. Then use that in
your formula.

NTaylor wrote:

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-
--
Nicki Taylor

--

Dave Peterson

All times are GMT +1. The time now is 02:41 AM.