Kimberly

=Lower(FirstName). Use Proper to keep the first letter in each word
capitalized.

hth,

Doug

"KimberlyC" wrote in message
...
Hi,
I have a formula in cell A3 of my worksheet that references another range
on a worksheet in the workbook.
The formula is:
=FirstName

Is there something I can add to this formula to convert all caps to lower
case ....if the user types the first name in all caps in the cell
(FirstName - range) the formula is referencing?

Thanks in advance for your help!
Kimberly