RE: Replacing special characters in Excel 2007

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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?
.

Relevant Pages

  • RE: Replacing special characters in Excel 2007
    ... use ~ before your asterisks in the find box. ... "Jeff" wrote: ... all non-zero three digit values. ...
    (microsoft.public.excel.worksheet.functions)
  • Replacing special characters in Excel 2007
    ... I need to Replace all occurrences of '***' (three asterisks) in an Excel ... all non-zero three digit values. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Replacing special characters in Excel 2007
    ... "Jeff" wrote: ... all non-zero three digit values. ... matches for three asterisks? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: D3 polling process
    ... "Jeff K" wrote in message ... time for some Lisinopril. ... I've been using this to check for numerics for years and years. ... digit, and nothing but digits. ...
    (comp.databases.pick)
  • Re: Sum function with asterisks
    ... expressions which will equate to True or False - when used in ... you can think of the asterisks are multiplying the values as Excel ... the A and B element is non-zero, ...
    (microsoft.public.excel.worksheet.functions)