阅读背景:

Excel:如何只在数组中获取文本以“SIM”开头的单元格

来源:互联网 

In excel I have column A with some numbers and letters and I would like to extract to a different column all the cells that start with "SIM" (ex, sim 3; sim 4; sim 5) and its correspondent value on column B and column C. I tried different methods using arrays but none worked as you can see the attached link. Link 2 is what I want the result to be. Thank you very much.In excel I have column A with some numbers and




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到:
你可能喜欢:
源码集中营 版权所有