首先你所谓的日期都不是日期格式,若仅仅是分开的话,只要你在AB2单元格输入公式:
=LEFT(AL2,FIND("-",AL2)-1)
AC2单元格输入公式:
=REPLACE(AL2,1,FIND("-",AL2),"")
若是要变成真正的日期,则公式为:
=SUBSTITUTE(LEFT(AL2,FIND("-",AL2)-1),".","-")
=SUBSTITUTE(REPLACE(AL2,1,FIND("-",AL2),""),".","-")
复制并下拉即可
温馨提示:答案为网友推荐,仅供参考