Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a large sentance that is in all caps in one cell.
So it looks like this "AS THE SON MICHAEL ARRANGES FOR THE BURIAL OF HIS FATHER AT HIS MOTHER'S REQUEST, THE TOUCHING STORY OF HIS PARENT'S COURTSHIP UNFOLDS. IN THE DAYS OF ARRANGED MARRIAGES, HE LEARNS THAT THEIR'S WAS THE FIRST BASED ON LOVE. <br<br" I am trying to lower case everything, but the first letter of the sentances and names, so in this case "As" and "Michael" and "In" would all stay capitalized but everything else would lower case. I have about 30,000 cells like this that the description is in all caps. Is there some sort of function that would help fix this for me? or am I SOL? Thanks for any help you can give me. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
MATCH function - 2 columns w/ SIMILAR, not EXACT data | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |