Thread: Find and Replace
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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
---


Reply With QuoteReply With Quote