How to convert from small to all caps

[Sonia Rokusek]

Does anyone know if there is a way to convert caps in an
already created document in Excel? I assumed that the
same font options would be available in Excel as in Word,
I was incorrect.

Thank you in advance-
Sonia

 

[J.E. McGimpsey]

Take a look here:

http://www.mvps.org/dmcritchie/excel/proper.htm#upper

(and yes - Word is a word processor, XL is a spreadsheet - the math
functions in Word are even more limited than the font options in XL).

 

[micheal hog]

Yes U can

There is simple solution of your problem
if u want font of cell if small alphabets you can use
=lower(cell)
if u want font of cell if capital alphabets you can use
=Upper(cell)
if u want font of cell if normal alphabets you can use
=proper(cell)

i hope you problem is resolve
thanks

any query contact (e-mail address removed)
http://hepatitis-info.blogspot.com