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.
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.
Install ASAPUtilities click hereSelect the whole sheet by clicking the grey square between A and 1.On the ASAPUtilities menu Text > Convert to UPPER case.
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
Enter this in sheet 2 cell A1=UPPER(Sheet1!A1)Sorry did not mention the A1Noldi
This thread is now locked and can not be replied to.
HTC U12 Plus review: Hands-on
Best Android emulators for Mac
Comment utiliser l’Apple Store Éducation ?
© Copyright 2018 IDG UK. All Rights Reserved.