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.