怎么讲excel中的小写字母转化成大写字母

具体步骤如下：

需要准备的材料分别是：电脑、Excel表格。

1、首先打开需要编辑的Excel表格，进入到编辑页面中。

2、然后在小写字母后面的单元格输入公式：=UPPER+小写字母单元格，回车确定。

3、然后鼠标左键点击单元格右下角下拉填充下面的单元即可。

输入如下公式，把A1替换成你需要的

="人民币"&(SUBSTITUTE(SUBSTITUTE(IF(A1<0,"负","")&TEXT(TRUNC(ABS(ROUND(A1,2))),"[DBNum2]")&"元"&IF(ISERR(FIND("",ROUND(A1,2))),"",TEXT(RIGHT(TRUNC(ROUND(A1,2)10)),"[DBNum2]"))&IF(ISERR(FIND("0",TEXT(A1,"000"))),"角","")&IF(LEFT(RIGHT(ROUND(A1,2),3))="",TEXT(RIGHT(ROUND(A1,2)),"[DBNum2]")&"分",IF(ROUND(A1,2)=0,"","整")),"零元零",""),"零元","零"))

假设A1为阿拉伯数字,要在B1显示大写金额

B1=IF(ROUND(A1,2)<0,"金额为负数无效",

IF(OR(ROUND(A1,2)=0, ROUND(A1,2)=""),"零元",TEXT(INT(ROUND(A1,2)),"[dbnum2]")&"元"&

IF(INT(ROUND(A1,2)100)=INT(ROUND(A1,2))100, "整",IF(INT(ROUND(A1,2)10)=INT(ROUND(A1,2))10,"零"&TEXT(INT(ROUND(A1,2)100)-INT(ROUND(A1,2)10)10,"[dbnum2]")&"分",IF(AND(INT(ROUND(A1,2)10)-INT(ROUND(A1,2))10>0,INT(ROUND(A1,2)100)-INT(ROUND(A1,2)10)10=0),TEXT(INT(ROUND(A1,2)10)-INT(ROUND(A1,2))10,"[dbnum2]")&"角整",TEXT(INT(ROUND(A1,2)10)-INT(ROUND(A1,2))10,"[dbnum2]")&"角"&TEXT(INT(ROUND(A1,2)100)-INT(ROUND(A1,2)10)10,"[dbnum2]")&"分")))))