Excel Study · Module 5: Text functions
Class 43FIND vs SEARCH
Intermediate2:11 videoFree
FIND and SEARCH both give the position of one piece of text inside another: in ravi@example.com the @ sign is character 5.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, A2 has an email address. Write a formula for D2 that gives the position of the @ sign.
The answer that works
✓ checked in Excel=FIND("@",A2)AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.