EXCEL 字符串截取 获取最后1个分割字符起始位置

# 替换分隔符

## 获取分隔符 将分隔符 替换 未空格 扩容 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)))