如下图,要求将A1单元格的小写英文字母转换为大写状态,结果在A2单元格列示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3c6d55fbb2fb4316f38fc60530a4462309f7d339?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
选中A2单元格,在单元格中输入[=],然后点击【插入函数】按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b3fb43166d224f4a8009cf6c19f790529822d139?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
弹出【插入函数】对话框:
在[或选择类别]中选择[全部]选项;
在[选择函数]中选择[LOWER]函数,这个函数帮助用户将大写英文字母转换为小写状态,然后点击【确定】按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/58ee3d6d55fbb2fbdebbe46d5f4a20a44623dc39?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
如下图,弹出【函数参数】对话框,将光标移动到第一个参数后面的对话框中,选择表格中的A1单元格,点击【确定】按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/54fbb2fb43166d22d0e7a9eb562309f79052d239?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
返回到工作表中,A1单元格的大写英文字母就转换为了小写状态。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/42166d224f4a20a4e78e80b880529822720ed039?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述