如果您使用的是 Excel,则可以在 VBA 中执行这一行:
left(Activecell.text,len(trim(replace(replace(activecell.Text,","," "),""""," "))))
我将从中到外解释一下:
replace(replace(activecell.Text,","," "),""""," ")
将所有逗号和双引号替换为空格
trim(replace(replace(activecell.Text,","," "),""""," "))
修剪它,即删除开头和结尾的空格
len(trim(replace(replace(activecell.Text,","," "),""""," ")))
获取修剪文本的长度
left(Activecell.text,len(trim(replace(replace(activecell.Text,","," "),""""," "))))
最后给我原始字符串的左侧部分,其中字符计数设置为我们计算出的长度减去开头和结尾的逗号和双引号。