convert all to capitals in excel

  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

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

Elsewhere on IDG sites

Samsung Galaxy Book 2: Release date, price and specs

This First Man soundtrack vinyl cover art is exquisitely composed

How to watch Apple’s October 2018 iPad launch

Meilleurs VPN (2018)