The Company Rocks Excels

Archive for the ‘Import Data’ Category

Posted in Import Data, Video Response to Viewers by Danny on October 18th, 2009

I am working through the special requests that viewers have sent me. In this lesson, I show you how to:

Use Data – Get External Data – to import a simple delimited text file.
Use Copy – Paste Special – Transpose – to make a copy of the imported data that is now “vertically oriented.” i.e. The field entries run down the column rather than across the rows.
Use the Data – Text-to-Columns feature to break an “address block” (City, State, Zip Code) that is one cell into three distinct cells. This is a terrific time saver!

Now available for purchase: My DVD “The 50 Best Tips, Tricks, and Techniques for Excel 2007″

Over 5 1/2 hours of training. Each video lesson focuses on one tip and averages 6 minutes.