回复 csn0603 的帖子
- =LEFT(A1,FIND("~",SUBSTITUTE(A1,",","~",3))-1)
复制代码
1 SUBSTITUTE(A1,",","~",3) 先把A1中第3个逗号换成一个在A1中不可能出现的字符(本例中用的是 “~”)
2 FIND("~",SUBSTITUTE(A1,",","~",3)) 查找 替换的符号在A1中出现的位置
3 =LEFT(A1,FIND("~",SUBSTITUTE(A1,",","~",3))-1) 提取要求的字符,A1中第3个逗号左边的字符,第3个逗号不提取
|