capitalize

How do I capitalise every other word but have the rest normal? Would look like this: John Oscar WILLIAMS Amelia Rose RICHARDS or The quick BROWN fox jumps OVER the lazy DOG. Is that even possible at all?

Is there any way using VBA to capitalize every proper word in a sentence? For example for the sentence: Beginning in 1910, the automobile industry sprang up in Detroit with 125 different auto companies. The rise of the city’s automobile industry spawned an upward movement of population and...

Hi! Whenever I dim an attribute to "shape" it makes it captialize weird. Say I type "dim shp as shape" it returns this "Dim shp as sHape" Anyone know why it would capitalize the "H"?

Hello all, How do you make a cell or whole selected area/spreadsheet automatically capitalize any inserted text to CAPITAL letters? Thank you. Much appreciated in advance.

I implemented the following VB code to my excel sheet where I want all input within multiple ranges forced to capital letters. Code is as follows: Private Sub Worksheet_Change(ByVal Target As Range) If Not (Application.Intersect(Target, Range("E9:CQ19, E22:CQ32, E35:C45")) Is Nothing) Then...

Hi all, I am looking for vba code or a macro the will capitalize the first letter of each word, and does not make any changes to acronyms. I am aware of the proper function, however it changes the letters in an acronym to lower case, except for the first. Is there a way to do this, either by...

In Excel 2003, I am referencing a text string and would like to return the text string with only the first letter capitalized. The PROPER function does not do this, as it capitalizes the first letter of every word. The formula below does however perform this, but I would like to write it as a...