Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting Text
Is there any way to make excel make every word in any cell begin with a
capital letter even if I type everything in lower case. Not just the beginning of the sentence but every word contained in the sentence. I'm using Office 2002 Thanks John |
#2
|
|||
|
|||
In A1 -- new york city In B1 -- =Proper(a1) displays
New York City HTH "JF" wrote in message ... Is there any way to make excel make every word in any cell begin with a capital letter even if I type everything in lower case. Not just the beginning of the sentence but every word contained in the sentence. I'm using Office 2002 Thanks John |
#3
|
|||
|
|||
"Jim May" wrote in message news:PuDke.16796$Fv.4842@lakeread01... In A1 -- new york city In B1 -- =Proper(a1) displays New York City HTH "JF" wrote in message ... Is there any way to make excel make every word in any cell begin with a capital letter even if I type everything in lower case. Not just the beginning of the sentence but every word contained in the sentence. I'm using Office 2002 Thanks John That's what I am looking for, but is there a way to format the whole page before i start typing. The sheet is basically a list of mp3's which I own and contains only text Thanks John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to select multiple text boxes in excel for formatting | New Users to Excel | |||
Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
Formatting text box | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |