Find/Replace does indeed work as I just ested it:

EditFind and Replace

In Find box: type ML
for Replace, LEAVE THIS BOX BLANK

(I put ML10 and ML11 in two separate cells, checked "replace all", an ML
disappeared)

Hope it works
Laura

"Anne Troy" wrote:

Why don't you just type the ML and copy it down? Can you find/replace and
change it? What are the other characters and are the 40 pages in one sheet
or 40 sheets?
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Hayette Hasham" <Hayette wrote in message
...
I hoping someone could help me with this. I want to delete all the contents
of a cell and only keep the word "ML". Can anyone help?
Very much appreciated as I have 40 pages of this to do.
Regards Hayette