With the attached sample file in the next comment.
About 11 seconds to replace AN for nothing on 16384 cells
About 36 seconds to replace AN for nothing on 32768 cells
About 168 seconds to replace AN for nothing on 65536 cells
The number of replacements increases the time to replace in a exponential way.
With Version: 4.1.6.1 Build ID: a59ce81388f477fc89db57f0c27f222f31884eb
about 15 seconds to replace 65536 cells
Reproducible with: 2cf968344d7adab 8dcfb2ba71 b0f521599204e82 7654e1fb8b 30d8cda1ebfd581 265cca5a0f 6a1576797f575b3 1ac6fa0ba3
Win7x64Ultimate
Version: 4.2.0.4 Build ID: 05dceb5d363845f
Version: 4.2.1.1 Build ID: d7dbbd7842e6a58
Version: 4.2.2.1 Build ID: 3be8cda0bddd8e4
Version: 4.2.3.3 Build ID: 6c3586f855673fa
With the attached sample file in the next comment.
About 11 seconds to replace AN for nothing on 16384 cells
About 36 seconds to replace AN for nothing on 32768 cells
About 168 seconds to replace AN for nothing on 65536 cells
The number of replacements increases the time to replace in a exponential way.
With Version: 4.1.6.1 Build ID: a59ce81388f477f c89db57f0c27f22 2f31884eb
about 15 seconds to replace 65536 cells