You point Excel’s Text Import Wizard to a file, and the wizard leads you through a few steps where it looks at the rows of data in the source file and makes suggestions based on the layout of the file. When you use the Text Import Wizard, you don’t open your data source in its native program. ![]() Importing! Yes, importing is not just for purveyors of fine art or exotic foods. Luckily for you, there’s a much better way to get that data into Excel. And copying from another program or from the web and pasting directly into a cell in a workbook might leave you with nightmarish looking results I’ve seen this, believe me. Whatever the case, I can guarantee you the last thing you’d ever want to do is retype it, so that option is out unless you really love typing and have tons of extra time on your hands. ![]() Where does this data come from? It might come from a database or some other program, or even the web. If you’ve worked with Excel long enough, you’ve probably needed to get data into Excel so that you can analyze it, or maybe create a chart.
0 Comments
Leave a Reply. |