You can use ~* in the find / replace dialog to replace asterisks. I've
included a macro that does the same.


Sub replaceasterisks

Cells.Replace What:="~*", Replacement:=InputBox("Replace Asterisks
with:"), LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False

End Sub


--
crispbd
------------------------------------------------------------------------
crispbd's Profile: http://www.excelforum.com/member.php...o&userid=10880
View this thread: http://www.excelforum.com/showthread...hreadid=320285