TheExcelAddict .com
Microsoft Excel "Quick Tips"

Pasting Text From A Web Page To Excel

I routinely copy information from web pages into Excel.

It's pretty simple. Copy and Paste. Right?

One thing you will notice when you first try this, is that the information is pasted into Excel with the original formatting from the web page intact. Often, this will be exactly what you want.

Sometimes you'll find that even graphics and HTML code gets pasted along with the data. Therefore, there will be times when you want to paste just the plain text, without the formatting.

Well, that's pretty simple too.

Select the text on the webpage that you want to copy, select Edit, Copy from your browser's menu (or use CTRL+C). Switch back to Excel and select Edit, Paste Special and choose the Text from the list of options.