Assuming source in A1 down

Try in B1:
="EMAIL/"&RIGHT(SUBSTITUTE(A1,"EMAIL/","-"),LEN(SUBSTITUTE(A1,"EMAIL/","-"))-1)
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lotta" wrote:
I have a problem with Find and replace.
I need to replace some characters in a Email adress.
Text is as follow:
EMAIL/ANNEMAIL/CHRISTINE.ANDERSSON*DOMAIN.COM
and I want it to be:
EMAIL/ANN-CHRISTINE.ANDERSSON*DOMAIN.COM
What I have tried is
Search for
EMAIL/*EMAIL/*
And here come the problem I want it to be like this (but it doesent work)
EMAIL/*-*

Hope you understand what I mean.

Regards Lotta