ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Importing a text file (https://www.excelbanter.com/excel-discussion-misc-queries/59704-importing-text-file.html)

Bill

Importing a text file
 
I'd like to import a text file into Excel 2000, of the format

data1/ data2/ data3/ data4

I want it so that cell1 = data1, cell2 = data2, etc.

Instead of a comma delimited file, I used a special character instead of the comma to
delimit the cells (represented by the "/" above).

How do I import that?

Thanks!

Bill.



Bill

Importing a text file
 
Never mind, I figured it out. If you open a text file in Excel, it asks the appropriate
questions.




All times are GMT +1. The time now is 03:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com