Convert text to uppercase.
Syntax
UPPER(text)
Text is the text that needs to be converted to uppercase. Text can be a quote or a text string.
When we enter English characters, we often need to convert uppercase and lowercase letters.
The UPPER function in the WPS table can convert the lowercase English format in the cell into uppercase format with one click, so you no longer have to worry about the case being caused by not switching between uppercase and lowercase Error.
Next, I will show you the specific steps of using this function in this table.
![表.png 表.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/fb9e026975a4b1ec66542dbe761345b5.png)
![图文对齐图.png 图文对齐图.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/e1ea7da86ff61befb1c583b6784f105d.png)
■ First select cell B2 and click Insert Function.
Find and select the UPPER function in the search box and click OK.
A dialog box will pop up with one parameter.
String is the text to be converted to uppercase letters, leaving non-alphabetic characters in the text unchanged.
Fill in A2, click OK, and Apple will become uppercase.
Position the cursor to the lower right corner of cell B2, and pull down to fill in the cell when the + font appears, and the modification can be completed in batches.
![GIF1.gif GIF1.gif](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/ceabc0b9b0969c252d2ecd23c8a5e26f.gif)
If you need to convert uppercase English characters into lowercase, you can check out the tutorial on the LOWER function.
评论列表(196条)
测试