A similar =proper function
 

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.

Any chance you could copy that range of cells to MSWord, then you can change it
to Sentence case.

Format|Change case|Sentence case

Then copy|paste back to excel.

Mcobra41 wrote:

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.

--

Dave Peterson