The FIND function specifies a string to be found within a bigger string and the number of characters from the beginning in the cell where this function is used. However, if the string is not found, it gives an error: "#VALUE" and writes #VALUE" in the cell. But, in such case I want to insert a blank in the cell. The "On Error goto.." command does not work. Nor does an If command work. Can you all help?
Bookmarks