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.
iMac Pro review
Why this awful City of Los Angeles job ad for a graphic designer is actually brilliant
Les meilleures prises CPL (2018)
© Copyright 2018 IDG UK. All Rights Reserved.