View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Lotta Lotta is offline
external usenet poster
 
Posts: 7
Default 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