120.623652,31.386228 | 120.623652 | 31.386228 |
上面数据要分成两列数据,我用了函数 =LEFT(C4,FIND(",",C4)-1),=RIGHT(C4,LEN(C4)-FIND(",",C4))
2023-12-23 16:22:46
120.623652,31.386228 | 120.623652 | 31.386228 |
上面数据要分成两列数据,我用了函数 =LEFT(C4,FIND(",",C4)-1),=RIGHT(C4,LEN(C4)-FIND(",",C4))