How To Change The Capitalisation Of Text In Cell

[hughLg]

How to change the case of text in cell?

 

[SkipVought]

Hi,

In the cell, you cannot change the case using spreadsheet functions.

You can use the Proper, Upper or Lower functions in another cell.

Or you could write a macro to loop thru a range and change the case in the cell.

Skip,
[sub]
[red][/red]
[/sub]

 

[macropod]

Hi hughLg,

As a follow-on from Skip's post, you could also use an all-capitals font ... You can find a lot of these by searching the web.

Cheers

[MS MVP - Word]

 

[SkipVought]

But...

What if the text is ALREADY caps? ;-)

Skip,
[sub]
[red][/red]
[/sub]

 

[macropod]

an all-lower-case font ??

[MS MVP - Word]

 

[SkipVought]

... oR mIxEd? ;-)

Skip,
[sub]
[red][/red]
[/sub]