Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
One more formula question--adding LOWER
My formula, thanks to everyone's wonderful help, has now evolved to:
=IF(LEFT(A1)="#",MID((UPPER(MID(A1,1,2))&LOWER(MID (A1,3,255))),2,255),IF(LEFT(A1)="%",UPPER(MID(A1,2 ,255)))) I'd like to add LOWER(A1) in there somehow, so if neither of these two conditions are met, it doesn't display "false," but it converts everything in cell A1 to lowercase. I've tried lots of things and nothing seems to work, please help me out one more time, I'd be forever grateful! Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
One more formula question--adding LOWER
=IF(LEFT(A1)="#",MID((UPPER(MID(A1,1,2))&LOWER(MID (A1,3,255))),2,255),
IF(LEFT(A1)="%",UPPER(MID(A1,2,255)), IF(EXACT(A1,LOWER(A1)),LOWER(A1)))) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "jezzica85" wrote in message ... My formula, thanks to everyone's wonderful help, has now evolved to: =IF(LEFT(A1)="#",MID((UPPER(MID(A1,1,2))&LOWER(MID (A1,3,255))),2,255),IF(LEF T(A1)="%",UPPER(MID(A1,2,255)))) I'd like to add LOWER(A1) in there somehow, so if neither of these two conditions are met, it doesn't display "false," but it converts everything in cell A1 to lowercase. I've tried lots of things and nothing seems to work, please help me out one more time, I'd be forever grateful! Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
One more formula question--adding LOWER
Hi Jessica
Try =IF(LEFT(A1)="#", MID((UPPER(MID(A1,1,2))&LOWER(MID(A1,3,255))),2,25 5), IF(LEFT(A1)="%", UPPER(MID(A1,2,255), LOWER(A1)))) -- Regards Roger Govier "jezzica85" wrote in message ... My formula, thanks to everyone's wonderful help, has now evolved to: =IF(LEFT(A1)="#",MID((UPPER(MID(A1,1,2))&LOWER(MID (A1,3,255))),2,255),IF(LEFT(A1)="%",UPPER(MID(A1,2 ,255)))) I'd like to add LOWER(A1) in there somehow, so if neither of these two conditions are met, it doesn't display "false," but it converts everything in cell A1 to lowercase. I've tried lots of things and nothing seems to work, please help me out one more time, I'd be forever grateful! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question about the "Match" formula | Excel Discussion (Misc queries) | |||
I have a question regarding countif formula. | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions |