LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Mcobra41
 
Posts: n/a
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlinks using R[1]C[1] and offset function in its cell referenc Elijah-Dadda Excel Worksheet Functions 0 March 5th 05 03:31 AM
MATCH function - 2 columns w/ SIMILAR, not EXACT data Jane Excel Worksheet Functions 3 March 5th 05 03:11 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
Trim function doesn't clean out ASCII Code 160 (Space) Ronald Dodge Excel Worksheet Functions 6 January 27th 05 03:48 AM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM


All times are GMT +1. The time now is 02:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"