二个逗号間城市 取出 (10253)

A2=TRIM(LEFT(RIGHT(SUBSTITUTE(B2,",",REPT(" ",99)),297),99))

另解=TRIM(MID(SUBSTITUTE(B2,",",REPT(" ",99)),(LEN(B2)-LEN(SUBSTITUTE(B2,",",""))-2)*99+1,99))