Mass delete mailto: entries in cells,

I have an accounts spreadsheet that I copy and paste customers names and addies into from the website back end sales information.

I do not copy e-mail addresses.

I have a mailto: with an e-mail address appear in the file in lots of places, it seems I delete it from some cells and it appears in others, my file is infested with the things now.

I can delete one by one, but this would take me weeks any ideas of how I can ctrl a select all cells and mass delete these things.

I am face with making a brand new accounts file which is a lot of work.

Thanks in advance

Hello Simon

Only the mailto: not the contents.

I can do it one by one, but there seems to be hundreds.

I have just worked out a temp solution, and recorded a macro that copied the delete action one one cell and run this through my whole sheet, only problem is its stuffed a load of formatting, but thats small beer compared to deleting one by one.

Could do with a better solution in future though,

Thanks

Hello Simon

Tried that, but its a hidden format and not an actual cell entry, that was my first point of call lol