Thread: Find replace
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Dave Curtis Dave Curtis is offline
external usenet poster
  
Posts: 100
Default Find replace
Hi,

In C1, try something like

=SUBSTITUTE(A1,B1,"")

and copy down.

Dave

url:http://www.ureader.com/msg/10356893.aspx
Reply With QuoteReply With Quote