Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Making a cell's contents lower case
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 |
#2
|
|||
|
|||
=LOWER(FirstName)
-- Kind Regards, Niek Otten Microsoft MVP - Excel "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 |
#3
|
|||
|
|||
Kimberly,
Yes, look up the LOWER function in Excel's help. Your formula would look like: =lower(FirstName) As a sidenote, the PROPER function will convert text to proper case. ---------------------------- Regards, John Mansfield http://www.pdbook.com "KimberlyC" wrote: 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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
Thank you all!!!
I've got it now!! :) "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion | Excel Worksheet Functions | |||
Amount or Numbers in Words | New Users to Excel | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |