Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...

Microsoft Excel has an import wizard, but if you structure the text correctly, you can bypass the wizard altogether.

Importing data into Excel from other sources can result in long, messy strings of text you need to parse. We'll show you how.