0
If your "Replace Text As You Type" option is supposed to replace text of length L with another text, then if the cell contains over 255 characters (including L), the "Replace Text As You Type" AutoCorrect option will not work.
Is this a bug? Is there any way to increase that limit?
SAL
Posted 2017-02-01T16:23:18.490
Reputation: 133
Excel is not a word processor. Certain functions stop working with more than 255 characters. You're not the first to comment on this. I'd say its a bug, but Microsoft likely will say its by design. – LPChip – 2017-02-01T16:34:19.560
@LPChip - It's not a bug, it's a feature. ... :P – BruceWayne – 2017-02-01T22:02:50.347