How do I replace * as a character in a string in Excel?

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

Guest

I can't figure out what punctuation needs to go before and after the * to
search for only *'s and not to use it as a Wildcard. In the help it says to
use brackets, but that is under the Microsoft Access help, and it didn't work
in Excel.
In the end, I plan to write a Macro that replaces the character '*' with the
number 3650 in all cells of my excel file (though I don't need help with the
Macro part, just how to type the character to be replaced).

Thanks for your help!
I've been searching the help pages for over an hour with no joy.
 
Use the 'tilde' character, e.g.

~* to find any strings containing a * char.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


nicolegt wrote :
 
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
How do you work with high character numbers? 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Find and replace a character in a cell with another cell's content 1
replace last character in string 5
Manipulating Strings in a Macro 2
MS word Find and Replace using Regex - Help required 0
Map characters to their relative positions in a cell 3

Back
Top