HeyI know in word that you can swap between Uppercase and Lowercase and First Letter of each word Capitals by using Shift+F3 But I was wondering if you can do it in excel and if so how do you do itThank You
PS I'm Using Office XP
Not so easy in Excel. You need to enter a formula in another cell. Say your text is in A1=UPPER(A)converts to capitals.=LOWER(A1)converts to lower case=PROPER(A1)converts to first character capitalised, rest lower case.
=UPPER(A1) I meant.
This thread is now locked and can not be replied to.
Surface Pro (2017) vs Surface Pro 4
Where HTML5 is headed next
MacBook Pro v Surface Pro 5
Synology invites you to visit them at Insomnia on 26th – 29th August. Book your tickets now and visit Synology.
© Copyright 2017 IDG UK. All Rights Reserved.