我知道如何使用其他定界符（例如逗号，等号等）分割文本。对于需要数字定界符的示例，我遇到了麻烦。
使用逗号分隔符的典型拆分公式如下所示：
=SPLIT(A1, ",")
我正在努力拆分看起来像这样的文本。分隔符是一个数字。
This is a random text of 20 characters but could be 30 characters as well.
输出应为
This is a random text of | 20 | characters but could be | 30 | characters as well.
请帮忙。谢谢
请尝试以下操作：
=SPLIT(REGEXREPLACE(A1,"\d+","|$0|"),"|")
删除空格可能更好：
=SPLIT(REGEXREPLACE(A1,"\s*(\d+)\s*","|$1|"),"|")
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句