更新时间2018-10-24 09:50:27
这个是最简单的引用
假设A1输入2018.10.18
效果图
E2输入公式:=LEFT(A2,FIND(".",A2)-1)&"年"&MID(A2,FIND(".",A2)+1,FIND("@",SUBSTITUTE(A2,".","@",2))-FIND(".",A2)-1)&"月"&RIGHT(A2,LEN(A2)-FIND("@",SUBSTITUTE(A2,".","@",2)))&"日"
=TEXT(SUBSTITUTE(A1,".","-"),"e年m月d日")