Extract characters after 2nd occurrence of a character but before the 3rd occurrence

[easybpw]

Hello and thanks in advance for your help.

I have a string of letters/numbers and I want to extract the information after the 2nd occurrence of "." but before the 3rd occurrence. For example:

2580.18B.AMEX.58TU.214758.854.982560

My result needs to be AMEX. I can extract prior to and after but I have no idea how to extract between. I also want to be able to adjust the formula if I need to extract after the 3rd or 4thth occurrence. AMEX is no constant as it could be anything. So I'm asking how to I extract from after the 2nd occurrence of "." but before the 3rd occurrence of ".".

Thanks again!

Bill

 

[Joe4]

If that example is indicative of the length of each piece roughly, try this for an entry in cell A1:

Between 2nd and 3rd occurrence:

=TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",100)),200,100))

Between 3rd and 4th occurrence:

=TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",100)),300,100))

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B
1
2	2580.18B.AMEX.58TU.214758.854.982560	AMEX
Main

Cell Formulas
Range	Formula
B2	B2	=FILTERXML("<k><m>"&SUBSTITUTE(A2,".","</m><m>")&"</m></k>","//m[3]")