我想要一个可以提取特定单词的Excel公式(如果字符总数为10) [英] I want an Excel Formula which can Extract Specific Word If total Character 10

问题描述

我想提取一些其他号码之间的单元格内的一些联系电话.想要这样的公式:如果463可用，并且463右侧的七个字符可用，则调用463并在其前面添加零，然后在其末尾添加其七个字符.

I want to extract some contact numbers inside a cell between some other numbers. Wanted formula like this "If 463 Available and If Seven Characters on Right Side of 463 Available then Call 463 and Add Zero Before it and Add its Seven Characters at end.

如果463不可用，则显示不可用

If 463 Not Available then show Not Available

如果463后七个字符不可用，则显示未完成

If Seven Characters Not Available after 463 then show Not Completed

数据

3498114632030377348901

9856979165879564897347

8978945618978946341897

结果

04632030377

Not Available

Not Completed

请让我知道该公式是否可行.

Please let me know the formula if it is possible.

推荐答案

=IFERROR(IF(LEN(A1)-FIND("463",A1)>=9,0&MID(A1,FIND("463",A1),10),"NOT COMPLETED"),"NOT AVAILABLE")

找到了一个较短的版本.

found a shorter version.

这篇关于我想要一个可以提取特定单词的Excel公式(如果字符总数为10)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！