Even with your added info, I believe Find/replace as I outlined will work in
seconds flat...

"Hayette Hasham" wrote:

Thanks for your answer, I very much appreciate it.

I have 40 pages to go through in the same file. The "ML" is attached to a
sentence, so will this work? For example... I have cells that say "Nail
Colour Shade 16ML"... these types of descriptions appear in cells/columns.. I
want to get rid of "NoML".
I hope this explains what I mean.

Hope you can help.
Hayette

"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