Thread: find email address in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default find email address in a cell
On Tue, 24 Jul 2007 09:00:04 -0700, Frederique
wrote:

From: Mail Delivery Subsystem

IF the email address is the only content that is enclosed in angles (<...)
then this should work:

=MID(A1,FIND("<",A1)+1,FIND("",A1)-FIND("<",A1)-1)
--ron
Reply With QuoteReply With Quote