ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   problem: cells with pictures (https://www.excelbanter.com/excel-discussion-misc-queries/41832-problem-cells-pictures.html)

yaniv_av

problem: cells with pictures
 

Hi,

I copy a table from a web page, and paste it into excel.
Now I want to do some calculation with the cells.
The problem is that one column contains a small picture within every
cell - so when I'm trying to perform any formula on that celss I get
error...

What can I do ?
10X !


--
yaniv_av
------------------------------------------------------------------------
yaniv_av's Profile: http://www.excelforum.com/member.php...o&userid=26558
View this thread: http://www.excelforum.com/showthread...hreadid=398298


Excel_Geek


Do you want the pictures?

If not, you can find the table you're copying using Firefox as a
browser, and then copy it and use the past special -- text function to
just paste the values from the table into excel. No formats or images.

HTH


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=398298



All times are GMT +1. The time now is 04:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com