Finding a Text String with an asterisk in it

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

Guest

I have loads of 'dirty data' with messages such as *DO NOT USE" AND **GONE
AWAY** on the customer address lines, how can I search for fields with the *
in them (this being a wild card and all that)

I use Access, Crystal and Excel so any suggestions on any of these apps
would be appreciated.
Ta
 
Woud u like to do it programmatically or manually. If for instance you
opened this file in exel an say u have "A*B**C" in cell A1. I'm assuming u
would like to replace these characters with say space thus cleaning the
text, then the following formula will replace asterisk with space and trim
extra spaces:
Cell B1 contains the formula: =TRIM(SUBSTITUTE(A1,"*"," "))
Ömer Ayzan
 
Back
Top