Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Import Problem
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Import Problem
What about using "Replace" from the "Edit" menu to fix the formulas that call
A1 and replace with E10? Might not be quite that simple, but could save a bunch of time. -- If my posting was helpful, please click the "Yes" button. ROCK ON!, Scott "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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import problem | New Users to Excel | |||
Problem import via query | New Users to Excel | |||
Data import problem | Excel Discussion (Misc queries) | |||
Import problem | New Users to Excel | |||
Import Data Problem | Excel Discussion (Misc queries) |