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.