FIND and SEARCH

Locate a word or character inside a longer text value.

Practical example

=SEARCH("@", A2)

Identify the source cells, apply the smallest reliable formula or tool, and test the result with changed data.