Clean up text
Pull the domain out of an email address
=TEXTAFTER(A2,"@")How it works in Excel
- A2 is the email address.
- "@" is the marker.
- Everything after it is returned.
- TEXTBEFORE gives the part before the @.
- It needs Microsoft 365.
The idea in general
You find the marker and keep what follows it.
What I assumed
- The email address is in A2.
Check the result on your own data before relying on it.