For The String Extraction Experts

[Guest]

I am trying to parse a single field to clean up an old database of addresses
for a friend.

How can I remove the word "and" as in John and Jane Doe while preserving the
fields that have "John's Automation Service"??


Thank you in advance

 

[Guest]

If you are going to update the existing data, please back up your data first.

Try with the use of the Replace function to replace the " and " word with
empty value ""

Replace([FieldName]," and " , "")