Replacing special characters in Excel 2007
 

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?

Replacing special characters in Excel 2007
 

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

"Jeff" wrote:

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?

Replacing special characters in Excel 2007
 

Thank you Sean. That worked. Best, Jeff

"Sean Timmons" wrote:

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

"Jeff" wrote:

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?

Replacing special characters in Excel 2007
 

Thank you for the feedback!

"Jeff" wrote:

Thank you Sean. That worked. Best, Jeff

"Sean Timmons" wrote:

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

"Jeff" wrote:

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?