Any takers on this? I still haven't found any methods to make this
work well other than multiple find and replace commands.

Thanks,
Andrew V. Romero

wrote:
I have some data like

ID Comments
12 No-DS/ALG PCN
13 NKMA/NO DS
15 Allergy PCN / HTN
16 All Lasix / NO/DS

I need to standarize many of the non-standard comments. So I am
looking for a way to go thru the comments field and find for example
NO-DS or NO DS or NO/DS or NKDS and replace all of those with NODS and
to also go thru and replace Allergy or ALL or Alg with Allergies. Any
ideas on how to do this? Ideally I would like to try making a table of
the items I wanted replaced and what to replace them with. For example
Find Replace
NO-DS NODS
NO/DS NODS
NKDS NODS
ALL Allergies
then use something like replace or vlookup to fix these, but I am not
sure how to get the formulas to use the table for the find and replace
pairs.

Thanks for any ideas,
Andrew V. Romero