Previous Topic Next Topic

CAP

Closed
TRISH - Oct 20, 2009 at 02:43 PM
 Trowa - Oct 22, 2009 at 08:09 AM
Hello,
I would like to know if you can change text from lower case to all capital without haveing to use caplocks and retype everything when working in excel?
Related:

2 responses

Answer 1 / 2
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Oct 21, 2009 at 07:24 AM
Hello

Try this
Copy to Word, make it to ALL CAPITALS, paste back to excel
Answer 2 / 2
Trowa
Oct 22, 2009 at 08:09 AM
There is also an excel function called UPPER to change all the lower case letters into capitals.