Say I'm writing a Conditional Format function, such as this one:
I want to add
TRIM() to each cell reference, but when I put the cursor at
= and then attempt to use the arrow keys to move through the text Excel thinks I'm trying to use the arrow keys to select cells and throws cell references into my formula. Is there a way to have Excel not do this, and just move through the text as normal, so I can edit it as I would in notepad.
Obviously there is a work-around of pasting the formula to notepad and back again, and there may be better ways to look for populated and non populated data.