通过搜索多个单词来拆分单元格内的字符串？
与此相似，
=RIGHT([@LinkToSharepointList],LEN([@LinkToSharepointList])-FIND("word1",[@LinkToSharepointList]))
但允许Word1，Word2，Word3等。
数据看起来就像
"https://sharepoint/sites/folder_name/this_is_a_long_word1 01.02.2020.xlsx"
"https://sharepoint/sites/folder_name/this_is_a_long_word3 01 02 2020.xlsx"
"https://sharepoint/sites/folder_name/this_is_a_long 01022020.xlsx"
我要返回日期，谢谢
Similar to this,
=RIGHT([@LinkToSharepointList],LEN([@LinkToSharepointList])-FIND("word1",[@LinkToSharepointList]))
But allowing for word1, word2, word3, etc..
The data looks like
"https://sharepoint/sites/folder_name/this_is_a_long_word1 01.02.2020.xlsx"
"https://sharepoint/sites/folder_name/this_is_a_long_word3 01 02 2020.xlsx"
"https://sharepoint/sites/folder_name/this_is_a_long 01022020.xlsx"
I'm trying to return the date, thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
假设：
您可以尝试：
B2中的公式：Assuming:
You could try:
Formula in
B2: