Excel FIND to CHARINDEX

FIND("@" , A2) is CHARINDEX('@', email). SQL returns 0 when it is missing.

CHARINDEX('@', email)  -- 0 if missing

Excel #VALUE! on a miss. SQL 0. Wrap with NULLIF(..., 0) if you want NULL.

Canonical translation

CHARINDEX('@', email)  -- 0 if missing

Then write it on a ticket

Monday is free. A colleague asks, you type, we mark it.

Clock in free