Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
Find and replace results can the appearance of find be different? | Excel Discussion (Misc queries) | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions |