=CONCATENATE(LEFT(D2838,3),TEXT((VALUE(RIGHT(D2838,4))+1),"0000"))想再问一下,这个又是什么,我不懂,麻
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/11 06:07:39
![=CONCATENATE(LEFT(D2838,3),TEXT((VALUE(RIGHT(D2838,4))+1),](/uploads/image/z/12096236-20-6.jpg?t=%3DCONCATENATE%28LEFT%28D2838%2C3%29%2CTEXT%28%28VALUE%28RIGHT%28D2838%2C4%29%29%2B1%29%2C%220000%22%29%29%E6%83%B3%E5%86%8D%E9%97%AE%E4%B8%80%E4%B8%8B%2C%E8%BF%99%E4%B8%AA%E5%8F%88%E6%98%AF%E4%BB%80%E4%B9%88%2C%E6%88%91%E4%B8%8D%E6%87%82%2C%E9%BA%BB)
xR]KA+CҀ=`B}@EEHYZ(HdDdI_៙>S>Ν3{cRp:Z¥,f̄#^CaEY^\
)+sG::~nU'{F5FOս`)(=7SRgf@? vͿXoBo{w> :I aV$4dO{5{[+re9|DKu\?F)2WFB#582TNM؋lF <
%F;G3fr g$Kd5d~\[ݦ'@C+
(}{a3j-dA%!%c/~*#a1LX!R%n`uȷ!0@#{^~N,=KQ
=CONCATENATE(LEFT(D2838,3),TEXT((VALUE(RIGHT(D2838,4))+1),"0000"))想再问一下,这个又是什么,我不懂,麻
=CONCATENATE(LEFT(D2838,3),TEXT((VALUE(RIGHT(D2838,4))+1),"0000"))想再问一下,这个又是什么,我不懂,麻
=CONCATENATE(LEFT(D2838,3),TEXT((VALUE(RIGHT(D2838,4))+1),"0000"))想再问一下,这个又是什么,我不懂,麻
CONCATENATE 是字符串拼接函数,意思是将此函数里的所有用逗号隔开的参数都拼接起来 LEFT(D2838,3),意思是取D2838中的前三个字符 RIGHT(D2838,4)是指取D2838中的后4个字符,再value,即此函数里的字符参数变为数值格式,为了后面再加个1,再text,即将上述数值再变为文本,"0000"是text的参数,是取为整数的意思,这样再用CONCATENATE函数将其拼接,
CONCATENATE与&的意思是一样的,上述函数还可以改成:
LEFT(D2838,3)&TEXT((VALUE(RIGHT(D2838,4))+1),"0000")