Apr 04 2020 05:44 AM
Good morning Microsoft Tech Community,
I am fairly new to Excel and quite amazed at how powerful this tool can be. I figured there would be no better place to find an answer than here!
What function /formula would I use to acknowledge an "abbreviated" text is found within a cell
see below: (In this case I simply want to add a formula in B1 and drop down, a "Y" would signify "yel" is within the text and "0" would indicate it is not)
Any help is greatly appreciated!!
Lucas
Apr 04 2020 06:18 AM
SolutionApr 04 2020 07:10 AM
Apr 04 2020 08:23 AM
Apr 04 2020 08:47 AM
@Abiola1 Not really! If found, it will return a number. If not, the result will be #VALUE!. Neither is a text, thus the result will always be "Y".
Perhaps you meant:
=IF(ISERROR(FIND("yel",A1)),0,"Y")
Apr 04 2020 09:20 AM
Apr 05 2020 03:29 PM
@Riny_van_Eekelen It worked! Greatly appreciate your help.
Apr 04 2020 06:18 AM
Solution