convert all to capitals in excel

  do-gull 19:29 05 Jun 06
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 06
  do-gull 19:55 05 Jun 06

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 06

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 06

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 06

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.

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…