I'm afraid you are think of Word. In Excel Shift+F3 is used to insert a
formula. If you're already in Edit mode, selecting characters in the formula
bar and pressing SHIFT+F3 does nothing (at least in XL2003).


On Fri, 23 Sep 2005 23:33:02 -0700, "Reba"
wrote:


select the text you want to change. press Shift F3.

"bj" wrote:

check out Proper() in help

"Robert Judge" wrote:

I have an EXCEL worksheet with columns including first name and last
name, in
all capital letters:

Column A is JOHN
Column B is SMITH

How can I change all the names so that, for example, JOHN becomes John
and
SMITH becomes Smith? I will appreciate help.