Thread: Find text in cell and copy from 4 characters in front of the found text.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Find text in cell and copy from 4 characters in front of the found text.
Hi,

Am Thu, 20 Feb 2014 16:58:17 +0100 schrieb Claus Busch:

=IF(ISNUMBER(FIND(2014,K6)),MID(K6,FIND(2014,K6)-4,8),"")

or:
=IFERROR(MID(K6,FIND(2014,K6)-4,8),"")


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote