| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 --- |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find and replace | Excel Discussion (Misc queries) | |||
| How to cancel a find & replace command "midstream"? | Excel Worksheet Functions | |||
| Macro: Find and replace | Excel Discussion (Misc queries) | |||
| Find and replace of word causes change of font formatting | New Users to Excel | |||
| VB Find and Replace | Excel Worksheet Functions | |||
Linear Mode
