Extracting string from a cell

[ks1987]

Hi,

Does anybody has a formula in excel/function in VBA handy which I can use to extract Base from the text string below :
[TABLE="width: 48"]
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY>[TR]
[TD="width: 64, bgcolor: transparent"]Ps_Base_AF.xlsx

Thanks,
ks1987[/TD]
[/TR]
</TBODY>[/TABLE]

 

[VoG]

Try

=MID(A1,FIND("_",A1)+1,FIND("_",SUBSTITUTE(A1,"_","~",1))-FIND("_",A1)-1)

 

[ks1987]

Works. Care to explain how you figured it out?

Thanks,
ks1987

 

[VoG]

FIND("_",A1)+1

locates the first _

FIND("_",SUBSTITUTE(A1,"_","~",1))

locates the second _ by substituting ~ for the second _

then the MID function returns the text between the first and second _

 

[ks1987]

That's really smart. Cheers.