其实是单位里的电话表来的，做表的人把名字和号码输入到一个单元格里去了，现在想把它们导入到手机里去，想分离开来，手工做又比较烦（主要是数量大，大约是700*3），有什么办法把A列里的内容分别按文字和数字拆开来放到B、C两列中去吗？

答案或建议：

比如A1为"张三13812345678",
B1的公式可以用
{=LEFT(A1,MIN(IF(ISERROR(FIND({"1","2","3","4","5","6","7","8","9","0"},A1)),100,FIND({"1","2","3","4","5","6","7","8","9","0"},A1)))-1)}
C1的公式可以用
{=MID(A1,MIN(IF(ISERROR(FIND({"1","2","3","4","5","6","7","8","9","0"},A1)),100,FIND({"1","2","3","4","5","6","7","8","9","0"},A1))),100)}

花括号为数组公式, 用CTRL+SHIFT+ENTER输入.
转载链接:http://www.baikewenda.com/h/1101/a37001.html