Select all the data to be fixed
Use Edit | Find/Replace
Replace what: MD
By: nothing (just leave the box empty)

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Martha" wrote in message
...
I have a worksheet with a list of docters names. Some have the acronym MD
and
some do not. How do i delete the acroynm from the entire spreadsheet and
still keep the doctors names?