FunkMaster_J Posted June 2, 2011 Posted June 2, 2011 Hi all, Apparently, many versions ago, Excel had the function to change a highlighted cell to lower/upper/proper case text. I've only known Excel to change text case via a formula/macro, but you need a source cell and a destination cell. The caller is adament the function to change the text case without a formula is still in Excel and wants us to find the 'button'. I was wondering if there actually is (or ever has been) a function do change text case? As the caller doesn't want to sift through this large spreadsheet finding the particular cells that need changing text case.
mac_shinobi Posted June 2, 2011 Posted June 2, 2011 Not the correct way of doing it as you describe but more of a dirty work around, have microsoft word open, copy said chunk of text from the cell, go to word Paste into word , highlight text --> go to Format --> Change Case --> select relevant option and click ok Copy the ammended text and paste back into excel Bit of a dirty work around but thats how I would do it Short of making your own VBA Form with said code ? Short of that there is the upper, lower and proper functions : =UPPER(CELL_REF) =Lower(CELL_REF) =Proper(CELL_REF)
FunkMaster_J Posted June 2, 2011 Author Posted June 2, 2011 I think it's getting too close Friday ... I can't find Format (or anything relating to Change Case) in Word 2010 :S The caller is more after a solution that she can do herself ... meaning VBA or any code writting is straight out the window.
mac_shinobi Posted June 2, 2011 Posted June 2, 2011 (edited) I think it's getting too close Friday ... I can't find Format (or anything relating to Change Case) in Word 2010 :S The caller is more after a solution that she can do herself ... meaning VBA or any code writting is straight out the window. How to Change Text Case in Word 2010 I am used to word 2003, never used 2010 yet According to the link above - Shift + F3 Unless you are using the toolbar menu option as per the screen grab Edited June 2, 2011 by mac_shinobi
mac_shinobi Posted June 2, 2011 Posted June 2, 2011 (edited) To change text case, select the text for which you want to change and click the button with text Aa in the Home tab under font sub group. As above Edited June 2, 2011 by mac_shinobi
FunkMaster_J Posted June 2, 2011 Author Posted June 2, 2011 Awesome, that works a treat Thanks! (I checked to see if that same drop-down list is in Excel, and it's not ... copy and paste like you suggested should do the trick though)
mac_shinobi Posted June 2, 2011 Posted June 2, 2011 no problem - you're welcome, sorry been busy. Frustrated now as can't find a compatable 2.5" to 3.5" adaptor to allow me to install my 2.5" SSD into my 2008 mac pro
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now