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.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

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

Why ecommerce hasn't taken off on social media

New MacBook Pro 2016 review | MacBook Pro with Touch Bar review: Apple's expensive and powerful…