View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default 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?