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.