I have a column with different information in it. I can use.
In this example I will be referencing A17.
=IF(ISNUMBER(SEARCH("front", A17)), "Front", "") to get the text "Front" in the cell
My question is, is it possible to do a similar IF function so search for "HUB" but not just paste "HUB". But instead paste the full HUB328 =IF(ISNUMBER(SEARCH("Hub", A17)), "XXXX", "") .
I want a function that i can use and drag down. For A17 it results in "HUB328". For A18 it results in "HUB329" etc.
I manually put the information in Column H.
I have downloaded Kutools but am still having a hard time navigating it
Thank you
Bookmarks