尝试:
=REGEXEXTRACT(A24, "(.+)-")+REGEXEXTRACT(B24, "(.+),")&"-"&
REGEXEXTRACT(A24, "-(.+)")+REGEXEXTRACT(B24, ",(.+)")
对于arrayformula做:
=ARRAYFORMULA(REGEXEXTRACT(A2:A, "(.+)-")+REGEXEXTRACT(B2:B, "(.+),")&"-"&
REGEXEXTRACT(A2:A, "-(.+)")+REGEXEXTRACT(B2:B, ",(.+)"))
我来说两句