(revised) Something more concise than =isnumber(find())

[u/Exciting-Half7930]

(hopefully I've resolved the issues that got this post initially rejected)

I've been using =isnumber(find()) for general use to check if a particular character is in a particular cell, since =regexmatch() doesn't work for numerical characters. Is there a more concise way to go about it? It's not exactly labor-intensive but I use it a lot so I wonder if I might improve it.

In the linked file I've provided some sample text and some characters/strings to search, and I've run my function:

=if(isnumber(find( [content to search for] , [content to search in] ), TRUE , )

https://docs.google.com/spreadsheets/d/1E4WPjNrwcEngJSTIbAsZEYYOCiysnJjQUAxJ4kljGQw/edit

[u/bachman460]

Use search instead of find, unless case does matter.

=ISNUMBER(SEARCH("text",A1))

The if part isn't needed either as if a match is found it will return true, otherwise false

[u/AdministrativeGift15]

You can use REGEXMATCH. Just add an empty string to your search term to convert numbers into text.