convert all to capitals in excel

  do-gull 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.

  GANDALF <|:-)> 19:37 05 Jun 2006
  do-gull 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.

  VoG II 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

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?