Thread: Find text in cell and copy from 4 characters in front of the found text.
View Single Post
  #2   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 14:51:03 +0000 schrieb dgenty:

Cell K6 contains A01677623022014AH014302BOX3 8ED

I want to find 2014 and past from 23022014 into another cell.

try:
=IF(ISNUMBER(FIND(2014,K6)),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