你可能喜欢
多项选择题
A.开始-设置单元格格式-文本
B.在身份证号前输入"’"
C.调整列宽
D.调整行宽
单项选择题
A.LEFT(A2,4)
B.MID(A2,1,4)
C.RIGHT(A2,4)
D.YEAR(A2)
多项选择题
A.SUBSTITUTE(A2,销售,营销)
B.SUBSTITUTE("销售",A2,"营销")
C.SUBSTITUTE("销售","营销",A2)
D.SUBSTITUTE(A2,"销售","营销")
多项选择题
A.DATEDIF("2019/9/23","2020/5/23",d)
B.DATEDIF("2019/9/23","2020/5/23","m")
C.DATEDIF("2020/5/23","2019/9/23","y")
D.DATEDIF("2019/9/23","2020/5/23","y")
多项选择题
A.TEXT(WEEKDAY(A2),"aaaa")
B.TEXT(WEEK(A2),"aaaa")
C.TEXT(WEEKDAY(A2,1),"aaaa")
D.TEXT(WEEKDAY(A2,1),"aaa")
多项选择题
A.WEEK(A2)
B.WEEKDAY(A2,1)
C.WEEKDAY(A2,2)
D.WEEKDAY(A2)