A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hi J G,
Good day.
In Excel, the Font group is located on the Home tab of the Ribbon. However, the Font group is used for formatting text, such as changing the font style, font size, bold, italic, underline, font color, and fill color. It does not include an option to convert lowercase text to uppercase.
Unlike Microsoft Word, Excel does not have a built-in Change Case button. To convert lowercase text to uppercase in Excel, you can use the UPPER function.
- For example, if the text you want to convert is in cell A1, you can enter the following formula in another cell: =UPPER(A1)
- This will convert the text in cell A1 to uppercase.
If you need to apply this to multiple rows, you can drag the formula down to the remaining cells. After that, if you want to replace the original values, you can copy the results and use Paste Special > Values only to paste them back into the original column.
This will paste only the converted uppercase text back into the original column, without keeping the formula.
For your reference, you may find these Microsoft articles helpful:
I hope this information is helpful. Should you have any further questions or need additional assistance, please feel free to share them in the comment below. I'm very happy to help.
If the answer is helpful, please click 'Yes' and kindly upvote it.
Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.