Sep 25 2022 05:24 PM
I am using Find("XYZ",C1). It works fine if XYZ is in the cell. If it is not I get #VALUE!
How can I make it blank if XYZ is not in the cell?
Sep 25 2022 11:45 PM - edited Sep 25 2022 11:46 PM
As a 365 user, a more verbose programming style can fit better into my workbook, for example
= LET(
position, FIND("xyz", Cell),
valid?, ISNUMBER(position),
IF(valid?, LEFT(Cell,position-1), "Not found")
)
would return the values to the left of the search string in the cell.