Search : in
By :

CAP

Last answer on Oct 22, 2009 1:09:58 pm BST TRISH, on Oct 20, 2009 7:43:57 pm BST 
 Report this message to moderators

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?

Configuration: Windows Vista Internet Explorer 8.0

1

Excelguru, on Oct 21, 2009 12:24:58 pm BST

Hello

Try this
Copy to Word, make it to ALL CAPITALS, paste back to excel A wise man once said, 'I complained that I had no shoes unti­l I met a man who had no feet.'
I am interested in financial Modelling and custom excel deve­lopment with excel macros.

Reply to Excelguru

2

 Trowa, on Oct 22, 2009 1:09:58 pm BST

There is also an excel function called UPPER to change all the lower case letters into capitals.

Reply to Trowa