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 :

Ps_Base_AF.xlsx Thanks, ks1987

<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY>
</TBODY>

 

[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.