convert all to capitals in excel

  [DELETED] 19:29 05 Jun 2006
Locked

hiya once again.
probably another easy problem for you lot.
I have created a document in excel in lowewr case and would like to convert the whole page to capitals, is this possible or not.

THANKS IN ADVANCE FOR ALL YOUR HELP.

  [DELETED] 19:37 05 Jun 2006
  [DELETED] 19:55 05 Jun 2006

TA!! GANDALF
BUT IT LOOKS SUCH A LONG WINDED WAY I DON'T THINK I WILL BOTHER.CHEERS FOR TAKING THE TIME TO REPLY ONCE AGAIN.
STEVE.

  [DELETED] 20:05 05 Jun 2006

Install ASAPUtilities click here


Select the whole sheet by clicking the grey square between A and 1.


On the ASAPUtilities menu Text > Convert to UPPER case.

  Noldi 20:27 05 Jun 2006

Enter this in sheet 2
=UPPER(Sheet1!A1)
Then copy and drag it across the rows you are using but not the whole sheet. That will give you a copy of Sheet 1 in upper case.

Noldi

  Noldi 20:29 05 Jun 2006

Enter this in sheet 2 cell A1
=UPPER(Sheet1!A1)

Sorry did not mention the A1

Noldi

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Amazon Prime Day 2018: Best Deals & Launches

The humble pint glass is redesigned from bottoms up by design legend Sir Kenneth Grange

The best Amazon Prime Day Apple deals 2018

Quel est le meilleur antivirus pour Windows ?