Which works for W

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Howard Kaikow" wrote in message
...
If you are sure that the characters are always at the start of a word, you
might try:

Cells.Replace What:="Mcw", Replacement:="McW", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _
ReplaceFormat:=False


--
http://www.standards.com/; Howard Kaikow's web site.
------------------------------------------------
"walt" wrote in message
...
Any ideas how to change all(!) Mc names from Mcwhatever to McWhatever ?

TIA Walt