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.



Why not print (CTRL+P) this tip and
share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict".
Subscribe at the TheExcelAddict.com/Newsletter.htm and you could win a really cool t-shirt.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright 2002 All Rights Reserved by FJH Marketing

Close this window