Replacing special characters in Excel 2007

J

Jeff

I need to Replace all occurrences of '***' (three asterisks) in an Excel
column with '0' (one zero) or '000' (three zeros). The Find function finds
all non-zero three digit values (which are numbers). Is there a way to find
matches for three asterisks?
 
S

Sean Timmons

use ~ before your asterisks in the find box. thsi will find actual instances
of *
 

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

Sum Function has small remainder 2
Word macro that can call cells out of Excel for a find and replace 0
Find/Replace Select Numbers in a Cell 3
Lower-Case Characters 2
AVERAGE 7
How Do I Find Different Values In A String? 2
ID Values 4
Actual solution 2

Top