IF + SEARCH and IF + FIND

Question

Dear Experts,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; How to populate Column "C" with SDX70 as well?So, basically if Column "A" has SDX65 text in it then "C" should be populated with SDX65 and if SDX70 then "C" should have SDX70, but instead I see it's showing #VALUES..&nbsp;Thanks &amp; RegardsAnupam Shrivastava

detlef_lewin · Answer

anupam1797&nbsp;You asked about the same problem a few days ago and got a working solution.https://techcommunity.microsoft.com/t5/excel/text-extraction/m-p/3860053&nbsp;

Forum Discussion

IF + SEARCH and IF + FIND

Share

Resources