CHANGE IT TO BIG LETTER

[Guest]

WHEN I WRITE IN THE CELL SMALL LATTER LONG SENTENCE AFTER THAT I WANT TO
CHANGE IT TO BIG LETTER
HOW CAN CHANGE IT
IT IS NOT LIKE THE WORD (PRESS SHIFT WITH F3

 

[norika]

Try function upper to change to captial letter

If you have already typee in a small letter in cell A1,
In Cell A2 type =Upper(A1)

norika

(PS no need to type in all caps, it is difficult to read an
considered
shouting in newsgroups

 

[David McRitchie]

If you mean sentence case, then see this macro by Tushar Mehta
http://google.com/[email protected]

For Proper Case and for UPPER case and lower case see my macros
http://www.mvps.org/dmcritchie/excel/proper.htm