Find & Replace *

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find/Replace MSWord wildcard characters from within Excel 6
Find and replace a character in a cell with another cell's content 1
Manipulating Strings in a Macro 2
Alt+Enter character 3
Find and replace "?" character 4
Replace more characters using replace 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How do you work with high character numbers? 3

Back
Top