# 替换分隔符
## 获取分隔符 将分隔符 替换 未空格 扩容 N倍
SUBSTITUTE(A6," ",REPT(" ",LEN)
##截取后N长度的字符,
RIGHT(SUBSTITUTE(A6," ",REPT(" ",500)),500))
## 将空格截取
TRIM(RIGHT(SUBSTITUTE(A6," ",REPT(" ",500)),500)))
## 整个字符长度 减去 最后一个字段长度
=LEN(A6)-LEN(TRIM(RIGHT(SUBSTITUTE(A6," ",REPT(" ",500)),500)))