replace only part before @ in a cell

[clausule]

Hello,

I have a column with email addresses and I'd like to replace the part before @ with info. How can I do this?

I thought about using find and replace, but in this case the part before @ should always be the same. In my column they are all different. I have no clue how to solve this. Any help is highly appreciated!

Clausule

[sktneer]

Assuming your email address in the cell A2, then try this.......

Please Login or Register  to view this content.

[AlKey]

Or this

	A	B	C	D
1	Email Address	Modified	New info from cell	Formulas
2	[email protected]	Type something [email protected]		=REPLACE(A2,1,FIND("@",A2)-1,"Type something here")
3	[email protected]	Add New [email protected]	Add New info	=REPLACE(A3,1,FIND("@",A3)-1,C3)

[vlady]

in Find/replace try.

Find What: *@
ReplaceWwith: yourtext@