Find & Replace *
 

I am trying to do an find and replace on the * character. The problem is that
the * character is the special character for all non blank cell contents. How
do I replace just the * character...

Thanks In Advance...

Find & Replace *
 

Sorry found it... ~*

"Jim Thomlinson" wrote:

I am trying to do an find and replace on the * character. The problem is that
the * character is the special character for all non blank cell contents. How
do I replace just the * character...

Thanks In Advance...

Find & Replace *
 

Jim,

Use ~* instead.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jim Thomlinson" wrote
in message
...
I am trying to do an find and replace on the * character. The
problem is that
the * character is the special character for all non blank cell
contents. How
do I replace just the * character...

Thanks In Advance...

Find & Replace *
 

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