LinkBack URL
About LinkBacks
Hello,
I would like to create a cell which convert any text written in it to capital letters.
Does anybody know how I can this be done?
Hello,
I would like to create a cell which convert any text written in it to capital letters.
Does anybody know how I can this be done?
Hi
The cell contents may be capitalized in an other cell with this function:
If A1 has the original text then use
Please Login or Register to view this content.
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
You will need a macro to achieve this.
Right click on Sheet Tab --> View Code --> Paste the code given below in the opened code window --> Save your workbook As Excel Macro-Enabled Workbook.
This code will covert the text entered into cell A1 into upper case.Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Works great. Thank you very much, it's helped me a lot with my project.
You're welcome.
If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks