![]() |
importing into Excell 2000
I have excell 2000 the instructions tel me to import a text file to go to
tools and look for an "Import" option. my excell has no import option. How do I import a comma deliniated text file into Excell and have it enter each deliniated area into a respective row A B C etc |
importing into Excell 2000
Hi
If it is a comma-dlimited file, Excel should just be able to open it and handle it correctly. What is the file's extension? If it is csv, you should be fine. If it's txt, then when you try to open it Excel should start the Import Wizard, which will guide you through the import. Hope this helps. Andy. "Doug Woodward" wrote in message ... I have excell 2000 the instructions tel me to import a text file to go to tools and look for an "Import" option. my excell has no import option. How do I import a comma deliniated text file into Excell and have it enter each deliniated area into a respective row A B C etc |
importing into Excell 2000
Just go to file open, change the file type to text and the import wizard
should start from there. You can than indicate which row to start the import, what the delimiter is, what columns to import and what data type each column contains. Excel uses the first row of data to determine the data type, so this is not always correct. -- Kevin Backmann "Doug Woodward" wrote: I have excell 2000 the instructions tel me to import a text file to go to tools and look for an "Import" option. my excell has no import option. How do I import a comma deliniated text file into Excell and have it enter each deliniated area into a respective row A B C etc |
importing into Excell 2000
THanks!
"Andy" wrote: Hi If it is a comma-dlimited file, Excel should just be able to open it and handle it correctly. What is the file's extension? If it is csv, you should be fine. If it's txt, then when you try to open it Excel should start the Import Wizard, which will guide you through the import. Hope this helps. Andy. "Doug Woodward" wrote in message ... I have excell 2000 the instructions tel me to import a text file to go to tools and look for an "Import" option. my excell has no import option. How do I import a comma deliniated text file into Excell and have it enter each deliniated area into a respective row A B C etc |
importing into Excell 2000
Thanks
"Kevin B" wrote: Just go to file open, change the file type to text and the import wizard should start from there. You can than indicate which row to start the import, what the delimiter is, what columns to import and what data type each column contains. Excel uses the first row of data to determine the data type, so this is not always correct. -- Kevin Backmann "Doug Woodward" wrote: I have excell 2000 the instructions tel me to import a text file to go to tools and look for an "Import" option. my excell has no import option. How do I import a comma deliniated text file into Excell and have it enter each deliniated area into a respective row A B C etc |
All times are GMT +1. The time now is 11:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com