close

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

Bring the .csv file into excel and save it as a .xls file. Then use that in
your formula.
NTaylor wrote:
gt;
gt; I know how to get my formulas to pull data from another workbook... but what
gt; if I want it to pull from an ascii, comma-delimited file? Then I am not sure
gt; if it can recognize columns/rows? Suggestions? Thanks-
gt; --
gt; Nicki Taylor

--

Dave Peterson

thanks.. I wanted it to be automatic. I think I figured out how to do it in
IMPORT DATA. Thanks though!
--
Nicki Taylorquot;Dave Petersonquot; wrote:

gt; Bring the .csv file into excel and save it as a .xls file. Then use that in
gt; your formula.
gt;
gt;
gt;
gt; NTaylor wrote:
gt; gt;
gt; gt; I know how to get my formulas to pull data from another workbook... but what
gt; gt; if I want it to pull from an ascii, comma-delimited file? Then I am not sure
gt; gt; if it can recognize columns/rows? Suggestions? Thanks-
gt; gt; --
gt; gt; Nicki Taylor
gt;
gt; --
gt;
gt; Dave Peterson
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()