Re: Macro and/or Formula to Find and Replace
Originally Posted by arnelgp
Just tested it again abd it does replace Drive with DR.
I wasn't saying it did not. What I was asking is DRIV comes before DRIVE in the range, so I would have expected it to replace in the word DRIVE, DRIV with DR giving DRE.
That is what happened to my attempt, which made me realise that the order in the substitute range can matter.?
Edit: Not to worry, I have fiound out why now.
Access novice. Sometimes trying to give something back.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Last edited by Gasman; 07-12-2018 at 02:58 AM.
Reason: Updated with method found