if i have an email-address with variable length in cell B9 for example email@example.com or firstname.lastname@example.org
and i want to build in B10 from the prefix of B9 and add only other suffix as text like @fish.com
The result in B10 should be email@example.com or firstname.lastname@example.org.
It should cut always only the text before the @ in B9 and add @fish.com as text.
I tried different formulas but not getting the result.
Can anybody help me? appreciate for your help