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