How to change lower case letter to capital case in same cell. Is it can done by automatic?
any want can help me
How to change lower case letter to capital case in same cell. Is it can done by automatic?
any want can help me
Hi!
Welcome to the forum!
What you are asking cannot be done in the same cell using a formula. You would have to use VBA macros. Ask your question in the VBA part of this forum, they will help you out.
Taming the Excel dragon... www.TheExcelphile.com
Instead of asking the same question in another subforum, its better to PM a mod to move the thread to that subforum. Alternatively, you can click the triangle with the ! mark and report the post asking for it to be moved.
If you create the same thread in a different subforum, it will be flagged as duplicate and you stand a chance of reducing your points.
I will move this thread for you today.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Ucase(range("A1"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks