Find and Replace
 

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

Find and Replace
 

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

Find and Replace
 

=SUBSTITUTE( A1, "EMAIL/", "-", 2 )
--
Regards,
Luc.

"Festina Lente"


"Max" wrote:

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

Find and Replace
 

=SUBSTITUTE( A1, "EMAIL/", "-", 2 )

A far better suggestion, Luc !
Now, why didn't I think of that earlier .. <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Find and Replace
 

Thansk alot this was greate.

Lotta

"PapaDos" skrev:

=SUBSTITUTE( A1, "EMAIL/", "-", 2 )
--
Regards,
Luc.

"Festina Lente"


"Max" wrote:

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