From: Gord Dibben on
F5>Special>Objects>OK

Delete


Gord Dibben MS Excel MVP

On Wed, 02 Jun 2010 19:36:54 +0200, Steve Hayes <hayesstw(a)telkomsa.net>
wrote:

>My wife was updating clients' addresses, and copied and pasted a fax number
>from one client's web site into her spreadsheet.
>
>Unfortunately it came with an image of a fax machine, which has now infested
>the entire spreadsheet.
>
>She has been deleting them one at a time, but that is going to take a long
>time with 1500 rows.
>
>Is there any quicker way of getting rid of them?