Hello everyone,
I have this formula here
And it works great!, however, I would like to add another find to the code.=IF(ISERROR(FIND("AB",A1,1)),"",FIND("AB",A1,1))
I would like "True" to display if excel finds AB in cell A1, OR DB in cell A1 and if nothing is found then nothing to be displayed.
I have tried many variations of this function to no avail.
How would this be accomplished? Can anyone help?
Thank you so much for your time.
Bookmarks