Excel thinks it knows the formula I want

[Tim Zych]

In cell B1 type in the formula "=A1 & A2" as quickly as
possible. When I do it on an XL2000 SR1 machine,
Excel "takes over" the formula and returns "=A1 &1:1"
after I type tye ampersand.

Why is this and is it possible to turn this "smart"
feature off?

 

[Chip Pearson]

Tim,

I've never seen that happen in any version of Excel, but it could be caused
by a sticky shift key. SHIFT+SPACE is the shortcut to select an entire row,
so when you type the ampersand (which requires SHIFT) and then hit space,
perhaps your shift key is still down.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Bob Phillips]

Tim,

It's because you don't release the shift key after typing the & and pressing
the spacebar. Do it myself all the time.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Tim Zych]

Aaaargh...why didn't I think of that! That's it. Thanks
Chip and Bob.