question

JonathanBrotto-3536 avatar image
0 Votes"
JonathanBrotto-3536 asked CeasarChenMSFT-3458 answered

Convert excel cell to upper case without formula

Is there a way to convert content in excel without using a formula to all uppercase?

worst case use =upper()

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

CeasarChenMSFT-3458 avatar image
0 Votes"
CeasarChenMSFT-3458 answered

Hi, @JonathanBrotto-3536
Excel has no other shortcut to change the case of cell contents without using formulas. A workaround is that you copy the excel's cells to Word, change the capitalization in the Word font group. In addition, you can also try to use VBA or add-ins to achieve, you can post about VBA under the tag of Office-vba-dev.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.