Hi folks.
Do you know by any chance how to toggle upper/lower case of text cell content ?
In MS Word, I can press SHIFT+F3 to do this. I would look for something similar in Excel, but couldn't find anything in the helpfile.
Thanks a bunch.
Hi folks.
Do you know by any chance how to toggle upper/lower case of text cell content ?
In MS Word, I can press SHIFT+F3 to do this. I would look for something similar in Excel, but couldn't find anything in the helpfile.
Thanks a bunch.
Helper column
=UPPER(A1)
=LOWER(A1)
=PROPER(A1)
depending on what you want
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
no built in excel ability to do that
you can yse a function upper()/lower()
but an add in or vba will do it. asap utilities
http://www.asap-utilities.com/
has an upper/lowercase option
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
You could use this and assign a shortcut as you prefer:
Please Login or Register to view this content.
Last edited by shg; 08-31-2009 at 03:38 PM.
Entia non sunt multiplicanda sine necessitate
WOW! thanks for your blazing fast replies guys !!!
I already knew that fuctions, I am sorry, I should have mentioned that right away.
Actually I was looking for something instantaneous ... just marking some text and press a hotkey to toggle upper/lower case. (Like SHIFT+F3 in Word...)
I feel inclined to say Caps Lock at this point
Well no ... Caps Lock has an effect on subsequent text input.
The idea is to modify already existing text.
To give you an example .... I have to import data on a regular basis and some of the text is all uppercase and difficult to read ... in Word I can just select the text and hit SHIFT+F3 .... conversion done, as easy as that.
But I will try the code for the shortcut posted above, I hope this will do it.
I'm sorry, but I couldn't find out how to assign code to a shortcut. You didn't mean, I should record a macro and modify it by adding the code there ? I looked in the help, and found how to change shortcuts for the menu entries, but not how to customize shortcuts (input code).
See Help for Run a macro
Okay, so when you posted the code above, you indeed intended it for using it with a macro, right ? (I was just guessing before ...)
It is a macro. It goes in a code module:
Adding a Macro to a Code Module
1. Copy the code from the post
2. Press Alt+F11 to open the Visual Basic Editor (VBE)
3. From the menu bar in the VBE window, do Insert > Module
4. Paste the code in the window that opens
5. Close the VBE to return to Excel
Last edited by boarders paradise; 08-31-2009 at 05:40 PM.
Well, problem solved ... but there is a small side-effect for me now ... Excel now always starts with PERSONAL.XLS opened. Can I do something in order for Excel to start with a default new document (I guess this is called "workbook1" in the English version, which I don't have) instead of PERSONAL.XLS ?
And the second problem I have is that the macro is not available in all .xls files I open. I am very experienced in MS Word, much less in Excel, but I thought that (in the same way as "normal.dot" for MS Word) Personal.xls would store macros that would be available application-wide, i.e. for any .xls file I open ...
What I did was:
(1) open PERSONAL.XLS
(2) create the macro as explained by you above
(3) macro now is in the Macro list (ALT+F8)
(4) I close PERSONAL.XLS
(5) restart Excel
(6) file >> new (STRG+N)
(7) macro is NOT listed in Macro List (Alt+F8)
Last edited by boarders paradise; 08-31-2009 at 06:01 PM.
Personal.xls should be hidden.
Do Window > Hide
wohoooo ... that solves both problems at once !!
While I do understand and find logical that after [window >> hide] Excel ceases to start up with PERSONAL.XLS opened, I don't really have a clue why now all of a sudden the macros in PERSONAL.XLS are available for other documents, now that PERSONAL.XLS is hidden ... while the macros weren't available for other documents, when PERSONAL.XLS was NOT hidden ...
But well .... I'm very happy that everything works now, maybe it's not that easy to explain the behaviour of the program anyway ...
Thanks again!
Last edited by boarders paradise; 08-31-2009 at 06:13 PM.
I need help!!! I want to do do the completely opposite of the function PROPER
A1 = HI MY NAME IS TOM
=PROPER(A1) --> Hi My Name Is Tom
I need a function that can Inverse this into --> hI mY nAME iS tOM
Example
A1 = AGJKHELKJHKLWSDJFK
I need a function that can do
A1 = aGJKHELKJHKLWSDJFK
How about this?
-GregPlease Login or Register to view this content.
YAY!!!! it's work!!
Now, that is for VBA. Is there a way I can do instantly? I mean I dont have to press the hot key and it will automatic converte
Please take a few mninutes to read the forum rules, and then start your own thread.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks