How to paste into Excel WITHOUT pictures, but formatting? (Facebook issue)

[attv]

Hi! Any idea how to paste into Excel WITHOUT pictures, but formatting and hyperlinks?

I basically want to copy-paste the results of a search from Facebook, places tab (for example looking for realtors in Dallas), and paste this into Excel. Like in the picture below:

Problem is - the pasting takes a lot of time and I have VBA to delete all pictures anyway, so I don't need them at all.

So I was wondering if anyone had an idea how can I avoid pasting pictures to Excel when you copy from the web?

 

[Asghar Hussain]

Try this,
Copy from Web paste in note pad and then copy from note pad and paste in excel

 

[attv]

Try this,
Copy from Web paste in note pad and then copy from note pad and paste in excel

This won't work as it will delete all hyperlinks, and I need them.

 

[EXCEL MAX]

Hello Attv,
try this...
Go to web page, Ctrl+A, Ctrl+C, Excel, right click, Paste special, select "Text" option, and "OK" in the end.

 

[EXCEL MAX]

Oh sorry, now I see you want to keep hyperlinks.
This works in Excel 2007, maybe newer versions allow something similar. Try ...
Select Excel "Data" tab, find "Get external data" on ribbon and select option "From Web".
In this Web Query insert destination address from where you want to copy data and press button "Go".
If errors occur press confirm button again few times. On right side select "Options" and check "Full HTML Formating".
Put mouse on top left corner to higlight selection (yellow arrow to right). Click to check.
Press "Import" button.

 

[Asghar Hussain]

Bro, Try this,
After images and links directly into Excel, Press ctrl+g, then click on special, select Objects and press delete.
Thanks

 

[Asghar Hussain]

Bro, Try this,
After pasting images and links directly into Excel, Press ctrl+g, then click on special, select Objects and press delete.
Thanks

 

[attv]

Bro, Try this,
After pasting images and links directly into Excel, Press ctrl+g, then click on special, select Objects and press delete.
Thanks

You miss the point. I know how to delete pictures after pasting them. I just don't want pictures to be pasted in the first place, since it's taking a lot of time.

Oh sorry, now I see you want to keep hyperlinks.
This works in Excel 2007, maybe newer versions allow something similar. Try ...
Select Excel "Data" tab, find "Get external data" on ribbon and select option "From Web".
In this Web Query insert destination address from where you want to copy data and press button "Go".
If errors occur press confirm button again few times. On right side select "Options" and check "Full HTML Formating".
Put mouse on top left corner to higlight selection (yellow arrow to right). Click to check.
Press "Import" button.

Unfortunately not working + too much wasting time with opening Facebook in Excel.


Guess will have to do this the long way around