excel学习笔记_北落依旧吧_百度贴吧
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&签到排名：今日本吧第个签到，本吧因你更精彩，明天继续来努力！
本吧签到人数：0可签7级以上的吧50个
本月漏签0次！成为超级会员，赠送8张补签卡连续签到：天&&累计签到：天超级会员单次开通12个月以上，赠送连续签到卡3张
关注：107贴子：
excel学习笔记
3D双端东方魔幻网游「大青云」勾魂公测,穿越逆转,封神故事,全新演绎!
=LOOKUP(A1,{1;2;3;4;5},A1*{100;200;300;400;500})
=MATCH(MAX(COUNTIF(B1:B100,B1:B100)),COUNTIF(B1:B100,B1:B100),)
=INDIRECT("a1")=INDIRECT(a1)
=REPT("★",11-SUM(LEN(B5),-1^MOD(INT((ROW()-3)/9),2)+(ROW()=2)*2))
=IF(ISERROR(FIND("201",B3))=FALSE,"停用",(IF((LEFT(A3,3)=("300"))+(A3="Y101")+(ISERROR(FIND("重庆分公司",B3))=FALSE),"重庆分公司",IF((LEFT(A3,1)="A"),"特许加盟店",(IF(LEFT(B3,3)="管理店","管理店",IF(LEFT(B3,3)="加盟店","加盟店",IF(LEFT(A3,2)="00","职能部门物品仓","直营店"))))))))
山寨版数据透视表=VALUE(CODE(A2)&MID(A2,2,8))=IF(ISERROR(A5),0,IF(A5=0,0,SMALL(Sheet2!B:B,COUNTIF(Sheet2!B:B,"&="&A5)+1)))=IF(ISERROR(A6),0,IF(A6=0,0,CHAR(LEFT(A6,2))&MID(A6,3,8)))=SUMIF(Sheet2!B:B,Sheet1!A6,Sheet2!D:D)局限性：核算项目有限制
文本转数字（仅限由大写字母及数字组成的代码）=VALUE(CODE(IF(MID(A2,1,1)=""," ",MID(A2,1,1)))&CODE(IF(MID(A2,2,1)=""," ",MID(A2,2,1)))&CODE(IF(MID(A2,3,1)=""," ",MID(A2,3,1)))&CODE(IF(MID(A2,4,1)=""," ",MID(A2,4,1)))&CODE(IF(MID(A2,5,1)=""," ",MID(A2,5,1)))&CODE(IF(MID(A2,6,1)=""," ",MID(A2,6,1)))&CODE(IF(MID(A2,7,1)=""," ",MID(A2,7,1))))数字转文本（仅限由大写字母及数字组成的代码）=SUBSTITUTE(CHAR(MID(B2,1,2))&CHAR(MID(B2,3,2))&CHAR(MID(B2,5,2))&CHAR(MID(B2,7,2))&CHAR(MID(B2,9,2))&CHAR(MID(B2,11,2))&CHAR(MID(B2,13,2))," ","")
Function zh(qqq)If IsError(qqq) Thenzh = ""ElseIf Len(qqq) = 1 Thenzh = Asc(qqq)ElseIf Len(qqq) = 2 Thenzh = Asc(qqq) & Asc(Mid(qqq, 2, 1))ElseIf Len(qqq) = 3 Thenzh = Asc(qqq) & Asc(Mid(qqq, 2, 1)) & Asc(Mid(qqq, 3, 1))ElseIf Len(qqq) = 4 Thenzh = Asc(qqq) & Asc(Mid(qqq, 2, 1)) & Asc(Mid(qqq, 3, 1)) & Asc(Mid(qqq, 4, 1))ElseIf Len(qqq) = 5 Thenzh = Asc(qqq) & Asc(Mid(qqq, 2, 1)) & Asc(Mid(qqq, 3, 1)) & Asc(Mid(qqq, 4, 1)) & Asc(Mid(qqq, 5, 1))ElseIf Len(qqq) = 6 Thenzh = Asc(qqq) & Asc(Mid(qqq, 2, 1)) & Asc(Mid(qqq, 3, 1)) & Asc(Mid(qqq, 4, 1)) & Asc(Mid(qqq, 5, 1)) & Asc(Mid(qqq, 6, 1))ElseIf Len(qqq) = 7 Thenzh = Asc(qqq) & Asc(Mid(qqq, 2, 1)) & Asc(Mid(qqq, 3, 1)) & Asc(Mid(qqq, 4, 1)) & Asc(Mid(qqq, 5, 1)) & Asc(Mid(qqq, 6, 1)) & Asc(Mid(qqq, 7, 1))Elsezh = ""End Ifzh = Val(zh)If zh = 0 Thenzh = ""Elsezh = zhEnd IfEnd Function"文本转数字宏代码,自己整的第一条代码，哈哈
是不是必须发汉字的回复呢我昨晚研究的函数代码怎么被吞了啊............
一次新的奇迹玩法？你想成为霸服大魔王吗？
Sub 判断工作表()
On Error Resume Next
If Sheets("data") Is Nothing Then
MsgBox ("搞毛啊，都没有工作表")
MsgBox ("算你狠")End Sub
Dim sName As String
sName = Strings.Format(Now, "yyyyMMdd") & "出货记录"
Sheets("Sheet3").Select
Sheets("Sheet3").Move
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Administrator\桌面\" & Format(Now, "yyyymmddhhmm") & ".xls",FileFormat:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False,CreateBackup:=False
MsgBox "已成功保存到桌面!"
Sub 新增()
r = Sheets("数据库").[a1000].End(xlUp).RowMsgBox rSheets("数据库").Cells(r + 1, 1) = [D8].Value
Sub 修改()
[a1] "=MATCH(制单!R12C4,数据库!C[-1],0)"
t = [a1].Value
Sheets("数据库").Cells(r, 1) = Now()
贴吧热议榜
使用签名档&&
保存至快速回贴汉字转拼音（第一个字母大写）
汉字转拼音（第一个字母大写）
发布时间： 18:13:24
编辑：www.fx114.net
本篇文章主要介绍了"汉字转拼音（第一个字母大写）"，主要涉及到汉字转拼音（第一个字母大写）方面的内容，对于汉字转拼音（第一个字母大写）感兴趣的同学可以参考一下。
using Susing System.Dusing System.Cusing System.Wusing System.Web.Susing System.Web.UI;using System.Web.UI.WebCusing System.Web.UI.WebControls.WebPusing System.Web.UI.HtmlCusing System.Cusing System.Tusing System.Text.RegularE
/// &summary&/// Hz2Py 的摘要说明/// &/summary&public class Hz2Py{&&& private static int[] pyValue = new int[]&&& {&&& -2,-2,-2,-2,-2,-2,&&& -2,-2,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1, -1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1,&&& -1,-1,-1,-1,-1,-1&&& };
&&& private static string[] pyName = new string[]&&& {&&& "A","Ai","An","Ang","Ao","Ba","Bai","Ban","Bang","Bao","Bei","Ben",&&& "Beng","Bi","Bian","Biao","Bie","Bin","Bing","Bo","Bu","Ba","Cai","Can",&&& "Cang","Cao","Ce","Ceng","Cha","Chai","Chan","Chang","Chao","Che","Chen","Cheng",&&& "Chi","Chong","Chou","Chu","Chuai","Chuan","Chuang","Chui","Chun","Chuo","Ci","Cong",&&& "Cou","Cu","Cuan","Cui","Cun","Cuo","Da","Dai","Dan","Dang","Dao","De",&&& "Deng","Di","Dian","Diao","Die","Ding","Diu","Dong","Dou","Du","Duan","Dui",&&& "Dun","Duo","E","En","Er","Fa","Fan","Fang","Fei","Fen","Feng","Fo",&&& "Fou","Fu","Ga","Gai","Gan","Gang","Gao","Ge","Gei","Gen","Geng","Gong",&&& "Gou","Gu","Gua","Guai","Guan","Guang","Gui","Gun","Guo","Ha","Hai","Han",&&& "Hang","Hao","He","Hei","Hen","Heng","Hong","Hou","Hu","Hua","Huai","Huan",&&& "Huang","Hui","Hun","Huo","Ji","Jia","Jian","Jiang","Jiao","Jie","Jin","Jing",&&& "Jiong","Jiu","Ju","Juan","Jue","Jun","Ka","Kai","Kan","Kang","Kao","Ke",&&& "Ken","Keng","Kong","Kou","Ku","Kua","Kuai","Kuan","Kuang","Kui","Kun","Kuo",&&& "La","Lai","Lan","Lang","Lao","Le","Lei","Leng","Li","Lia","Lian","Liang",&&& "Liao","Lie","Lin","Ling","Liu","Long","Lou","Lu","Lv","Luan","Lue","Lun",&&& "Luo","Ma","Mai","Man","Mang","Mao","Me","Mei","Men","Meng","Mi","Mian",&&& "Miao","Mie","Min","Ming","Miu","Mo","Mou","Mu","Na","Nai","Nan","Nang",&&& "Nao","Ne","Nei","Nen","Neng","Ni","Nian","Niang","Niao","Nie","Nin","Ning",&&& "Niu","Nong","Nu","Nv","Nuan","Nue","Nuo","O","Ou","Pa","Pai","Pan",&&& "Pang","Pao","Pei","Pen","Peng","Pi","Pian","Piao","Pie","Pin","Ping","Po",&&& "Pu","Qi","Qia","Qian","Qiang","Qiao","Qie","Qin","Qing","Qiong","Qiu","Qu",&&& "Quan","Que","Qun","Ran","Rang","Rao","Re","Ren","Reng","Ri","Rong","Rou",&&& "Ru","Ruan","Rui","Run","Ruo","Sa","Sai","San","Sang","Sao","Se","Sen",&&& "Seng","Sha","Shai","Shan","Shang","Shao","She","Shen","Sheng","Shi","Shou","Shu",&&& "Shua","Shuai","Shuan","Shuang","Shui","Shun","Shuo","Si","Song","Sou","Su","Suan",&&& "Sui","Sun","Suo","Ta","Tai","Tan","Tang","Tao","Te","Teng","Ti","Tian",&&& "Tiao","Tie","Ting","Tong","Tou","Tu","Tuan","Tui","Tun","Tuo","Wa","Wai",&&& "Wan","Wang","Wei","Wen","Weng","Wo","Wu","Xi","Xia","Xian","Xiang","Xiao",&&& "Xie","Xin","Xing","Xiong","Xiu","Xu","Xuan","Xue","Xun","Ya","Yan","Yang",&&& "Yao","Ye","Yi","Yin","Ying","Yo","Yong","You","Yu","Yuan","Yue","Yun",&&& "Za", "Zai","Zan","Zang","Zao","Ze","Zei","Zen","Zeng","Zha","Zhai","Zhan",&&& "Zhang","Zhao","Zhe","Zhen","Zheng","Zhi","Zhong","Zhou","Zhu","Zhua","Zhuai","Zhuan",&&& "Zhuang","Zhui","Zhun","Zhuo","Zi","Zong","Zou","Zu","Zuan","Zui","Zun","Zuo"&&& };
&&& public Hz2Py()&&& {&&&&&&& //&&&&&&& // TODO: 在此处添加构造函数逻辑&&&&&&& //&&& }
&&& /// &summary&&&& /// 把汉字转换成拼音(全拼)&&& /// &/summary&&&& /// &param name="hzString"&汉字字符串&/param&&&& /// &returns&转换后的拼音(全拼)字符串&/returns&&&& public static string Convert(string hzString)&&& {&&&&&&& // 匹配中文字符&&&&&&& Regex regex = new Regex("^[/u4e00-/u9fa5]$");&&&&&&& byte[] array = new byte[2];&&&&&&& string pyString = "";&&&&&&& int chrAsc = 0;&&&&&&& int i1 = 0;&&&&&&& int i2 = 0;&&&&&&& char[] noWChar = hzString.ToCharArray();
&&&&&&& for (int j = 0; j & noWChar.L j++)&&&&&&& {&&&&&&&&&&& // 中文字符&&&&&&&&&&& if (regex.IsMatch(noWChar[j].ToString()))&&&&&&&&&&& {&&&&&&&&&&&&&&& array = System.Text.Encoding.Default.GetBytes(noWChar[j].ToString());&&&&&&&&&&&&&&& i1 = (short)(array[0]);&&&&&&&&&&&&&&& i2 = (short)(array[1]);&&&&&&&&&&&&&&& chrAsc = i1 * 256 + i2 - 65536;&&&&&&&&&&&&&&& if (chrAsc & 0 && chrAsc & 160)&&&&&&&&&&&&&&& {&&&&&&&&&&&&&&&&&&& pyString += noWChar[j];&&&&&&&&&&&&&&& }&&&&&&&&&&&&&&& else&&&&&&&&&&&&&&& {&&&&&&&&&&&&&&&&&&& // 修正部分文字&&&&&&&&&&&&&&&&&&& if (chrAsc == -9254)& // 修正&圳&字&&&&&&&&&&&&&&&&&&&&&&& pyString += "Zhen";&&&&&&&&&&&&&&&&&&& else&&&&&&&&&&&&&&&&&&& {&&&&&&&&&&&&&&&&&&&&&&& for (int i = (pyValue.Length - 1); i &= 0; i--)&&&&&&&&&&&&&&&&&&&&&&& {&&&&&&&&&&&&&&&&&&&&&&&&&&& if (pyValue[i] &= chrAsc)&&&&&&&&&&&&&&&&&&&&&&&&&&& {&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& pyString += pyName[i];&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& }&&&&&&&&&&&&&&&&&&&&&&& }&&&&&&&&&&&&&&&&&&& }&&&&&&&&&&&&&&& }&&&&&&&&&&& }&&&&&&&&&&& // 非中文字符&&&&&&&&&&& else&&&&&&&&&&& {&&&&&&&&&&&&&&& pyString += noWChar[j].ToString();&&&&&&&&&&& }&&&&&&& }&&&&&&& return pyS&&& }
本文标题：
本页链接：Excel将汉字名字，转换为大写的拼音，全称
添加个模块（操作：打开excel--按alt+F11--插入--模块）将下列内容复制粘贴至模块中，点击“保存”。然后在Excel中就可以转换了。
Function PinYin(Hz As String)
Dim PinMa As String
Dim MyPinMa As Variant
Dim Temp As Integer, i As Integer, j As
"a,20319,ai,20317,an,20304,ang,20295,ao,20292,"
PinMa = PinMa &
"ba,20283,bai,20265,ban,20257,bang,20242,bao,20230,bei,20051,ben,20036,beng,20032,bi,20026,bian,20002,biao,19990,bie,19986,bin,19982,bing,19976,bo,19805,bu,19784,"
PinMa = PinMa &
"ca,19775,cai,19774,can,19763,cang,19756,cao,19751,ce,19746,ceng,19741,cha,19739,chai,19728,chan,19725,chang,19715,chao,19540,che,19531,chen,19525,cheng,19515,chi,19500,chong,19484,chou,19479,chu,19467,chuai,19289,chuan,19288,chuang,19281,chui,19275,chun,19270,chuo,19263,ci,19261,cong,19249,cou,19243,cu,19242,cuan,19238,cui,19235,cun,19227,cuo,19224,"
PinMa = PinMa &
"da,19218,dai,19212,dan,19038,dang,19023,dao,19018,de,19006,deng,19003,di,18996,dian,18977,diao,18961,die,18952,ding,18783,diu,18774,dong,18773,dou,18763,du,18756,duan,18741,dui,18735,dun,18731,duo,18722,"
PinMa = PinMa &
"e,18710,en,18697,er,18696,"
PinMa = PinMa &
"fa,18526,fan,18518,fang,18501,fei,18490,fen,18478,feng,18463,fo,18448,fou,18447,fu,18446,"
PinMa = PinMa &
"ga,18239,gai,18237,gan,18231,gang,18220,gao,18211,ge,18201,gei,18184,gen,18183,geng,18181,gong,18012,gou,17997,gu,17988,gua,17970,guai,17964,guan,17961,guang,17950,gui,17947,gun,17931,guo,17928,"
PinMa = PinMa &
"ha,17922,hai,17759,han,17752,hang,17733,hao,17730,he,17721,hei,17703,hen,17701,heng,17697,hong,17692,hou,17683,hu,17676,hua,17496,huai,17487,huan,17482,huang,17468,hui,17454,hun,17433,huo,17427,"
PinMa = PinMa &
"ji,17417,jia,17202,jian,17185,jiang,16983,jiao,16970,jie,16942,jin,16915,jing,16733,jiong,16708,jiu,16706,ju,16689,juan,16664,jue,16657,jun,16647,"
PinMa = PinMa &
"ka,16474,kai,16470,kan,16465,kang,16459,kao,16452,ke,16448,ken,16433,keng,16429,kong,16427,kou,16423,ku,16419,kua,16412,kuai,16407,kuan,16403,kuang,16401,kui,16393,kun,16220,kuo,16216,"
PinMa = PinMa &
"la,16212,lai,16205,lan,16202,lang,16187,lao,16180,le,16171,lei,16169,leng,16158,li,16155,lia,15959,lian,15958,liang,15944,liao,15933,lie,15920,lin,15915,ling,15903,liu,15889,long,15878,lou,15707,lu,15701,lv,15681,luan,15667,lue,15661,lun,15659,luo,15652,"
PinMa = PinMa &
"ma,15640,mai,15631,man,15625,mang,15454,mao,15448,me,15436,mei,15435,men,15419,meng,15416,mi,15408,mian,15394,miao,15385,mie,15377,min,15375,ming,15369,miu,15363,mo,15362,mou,15183,mu,15180,"
PinMa = PinMa &
"na,15165,nai,15158,nan,15153,nang,15150,nao,15149,ne,15144,nei,15143,nen,15141,neng,15140,ni,15139,nian,15128,niang,15121,niao,15119,nie,15117,nin,15110,ning,15109,niu,14941,nong,14937,nu,14933,nv,14930,nuan,14929,nue,14928,nuo,14926,"
PinMa = PinMa &
"o,14922,ou,14921,"
PinMa = PinMa &
"pa,14914,pai,14908,pan,14902,pang,14894,pao,14889,pei,14882,pen,14873,peng,14871,pi,14857,pian,14678,piao,14674,pie,14670,pin,14668,ping,14663,po,14654,pu,14645,"
PinMa = PinMa &
"qi,14630,qia,14594,qian,14429,qiang,14407,qiao,14399,qie,14384,qin,14379,qing,14368,qiong,14355,qiu,14353,qu,14345,quan,14170,que,14159,qun,14151,"
PinMa = PinMa &
"ran,14149,rang,14145,rao,14140,re,14137,ren,14135,reng,14125,ri,14123,rong,14122,rou,14112,ru,14109,ruan,14099,rui,14097,run,14094,ruo,14092,"
PinMa = PinMa &
"sa,14090,sai,14087,san,14083,sang,13917,sao,13914,se,13910,sen,13907,seng,13906,sha,13905,shai,13896,shan,13894,shang,13878,shao,13870,she,13859,shen,13847,sheng,13831,shi,13658,shou,13611,shu,13601,shua,13406,shuai,13404,shuan,13400,shuang,13398,shui,13395,shun,13391,shuo,13387,si,13383,song,13367,sou,13359,su,13356,suan,13343,sui,13340,sun,13329,suo,13326,"
PinMa = PinMa &
"ta,13318,tai,13147,tan,13138,tang,13120,tao,13107,te,13096,teng,13095,ti,13091,tian,13076,tiao,13068,tie,13063,ting,13060,tong,12888,tou,12875,tu,12871,tuan,12860,tui,12858,tun,12852,tuo,12849,"
PinMa = PinMa &
"wa,12838,wai,12831,wan,12829,wang,12812,wei,12802,wen,12607,weng,12597,wo,12594,wu,12585,"
PinMa = PinMa &
"xi,12556,xia,12359,xian,12346,xiang,12320,xiao,12300,xie,12120,xin,12099,xing,12089,xiong,12074,xiu,12067,xu,12058,xuan,12039,xue,11867,xun,11861,"
PinMa = PinMa &
"ya,11847,yan,11831,yang,11798,yao,11781,ye,11604,yi,11589,yin,11536,ying,11358,yo,11340,yong,11339,you,11324,yu,11303,yuan,11097,yue,11077,yun,11067,"
PinMa = PinMa &
"za,11055,zai,11052,zan,11045,zang,11041,zao,11038,ze,11024,zei,11020,zen,11019,zeng,11018,zha,11014,zhai,10838,zhan,10832,zhang,10815,zhao,10800,zhe,10790,zhen,10780,zheng,10764,zhi,10587,zhong,10544,zhou,10533,zhu,10519,zhua,10331,zhuai,10329,zhuan,10328,zhuang,10322,zhui,10315,zhun,10309,zhuo,10307,zi,10296,zong,10281,zou,10274,zu,10270,zuan,10262,zui,10260,zun,10256,zuo,10254"
MyPinMa = Split(PinMa, ",")
For i = 1 To Len(Hz)
Temp = Asc(Mid(Hz, i, 1))
If Temp & 0 Then
Temp = Abs(Temp)
For j = 791 To 1 Step -2
If Temp &= Val(MyPinMa(j)) Then
&&&&&&&&&&&&&
PinYin = PinYin & MyPinMa(j - 1) &
&&&&&&&&&&&&&
PinYin = Trim(PinYin)
End Function
以上拼音码表是从网上一些工具源文伯中获得,未全部验证其准确性,但愿不会有错吧!至于算法就是根据汉字ASC码与码表进行比对,有点难看.使用中发现上边码表所获仅限于GB2312-80 I
然后再任意单元格输入
=pinyin(a1)
就把a1中的汉字转换成拼音了。
有关EXCEL大小写字母转换的几个函数
在使用Excel过程中，经常会遇到需要转换大小写字母的情况，主要是为了文档内容统一，整齐美观。
将英文单词首字母转换为大写
PROPER函数
用途：将文字串的首字母及任何非字母字符之后的首字母转换成大写。将其余的字母转换成小写。
语法：PROPER(text)
参数：Text是需要进行转换的字符串，包括双引号中的文字串、返回文本值的公式或对含有文本的单元格引用等。
实例1：如果A1=学习excel，则公式“=PROPER(A1)”返回“学习Excel”。
实例2：假如你在A1单元格输入了“ZHONGHUA ROAD”，
然后你在B1单元格输入公式：=PROPER(A1 )
然后回车，B1显示的结果就是“Zhonghua Road”。
将大写字母转换为小写
用途：将一个文本字符串中的所有大写字母转换为小写字母。
语法：LOWER(text)
参数：Text
是要转换为小写字母的文本。函数 LOWER
不改变文本中的非字母的字符。
以上面例子2为例子，如果在B1单元格输入公式：=LOWER(A1 )
，则回车后B1单元格内容为“zhonghua road”，全部大写字母转换为小写。
将所有小写字母转换为大写
用途：将文本转换成大写形式。
语法：UPPER(text)
参数：Text
为需要转换成大写形式的文本。Text
可以为引用或文本字符串。
示例：如果您将示例复制到空白工作表中，可能会更易于理解该示例。
Movies艺术
说明（结果）
=UPPER(A2)
第一个字符串大写(MOVIES艺术)
=UPPER(A3)
第二个字符串大写(JAVA技术
已投稿到：
以上网友发言只代表其个人观点，不代表新浪网的观点或立场。