left, search mid
Hi again,
Am Tue, 7 Jun 2016 20:41:35 +0200 schrieb Claus Busch:
try:
=--MID(C2,FIND("(",C2)+1,FIND(")",C2)-FIND("(",C2)-1)
and
=--SUBSTITUTE(MID(C2,FIND("#",SUBSTITUTE(C2,"(","#",2 ))+1,99),")",)
another suggestion:
=--REPLACE(REPLACE(C2,FIND(")",C2),99,),1,FIND("(",C2 ),)
and
=--SUBSTITUTE(REPLACE(C2,1,FIND("#",SUBSTITUTE(C2,"(" ,"#",2)),),")",)
Regards
Claus B.
--
Windows10
Office 2016
|