Thread: Import Problem
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Import Problem

Hi,

You can open a text file directly into Excel via File, Open. In which case
it doesn't matter where you are because Excel automatically opens the file as
a new file, which you can then copy over to any location you choose in
another workbook. You still get the import wizard.

If you are doing this via the Data, Import External Data, Import Data
command you are prompted for the location where you want to put the data so
you can select E1 rather than A1 or any other cell.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Pepper" wrote:

Using Excel 2003, my problem is to import from a csv file into Excel. Easy
enough, except I require the top, leftmost cell to be in E10 not A1.
There are a lot of text entries, and formulas already in place, and avoiding
redoing those everytime a download and import is ordered will be a great
enhancement to efficient operations.
Thanks
Pepper