Converting Text
Hi Ty,
Am Thu, 28 Jun 2012 13:00:28 -0700 (PDT) schrieb Ty:
System A
NA-SMG-SA-CARDS
NA-SMG-SA-EBZ
NA-SMG-SA-RAL
NA-SMG-SA-RAT
NA-SMG-SA-RNBAW
Sytem B
SCNCRDU
SCNEBZU
SCNRALU
SCNRATU
SCNRBU
system A in E2:E6, System B in C2:C6, then:
=IF(LEN(E2)=15,INDEX($C$2:$C$6,MATCH("*"&MID(E2,11 ,1)&MID(E2,13,1)&"*",$C$2:$C$6,0)),INDEX($C$2:$C$6 ,MATCH("*"&MID(E2,11,4)&"*",$C$2:$C$6,0)))
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|