Substituting text

I have several possible variations of text I need to standardize as I'm updating files.

For example:
In different files, cell I5 may contain "apple dapple" , "sour apple", "apple pie" or "apple strudel". (The placement of the text may vary withing the cell...)

As I loop through the files updating, I want any files that have a variation of this to have it replaced with "apple", because later the in the code the cell contents are used to create a folder and in a saveas function.

I tried this, but no luck:

Please Login or Register  to view this content.

All I need if how to replace this, I've got the other steps ready to go...

THanks
Ted

Hello Ted,

To catch all occurrences of the word "apple", you need to use Regular Expressions. This example checks for word apple with a trailing space, space before and after, and a space before it at the end of sentence or word group.

Please Login or Register  to view this content.

Sincerely,
Leith Ross