Combing FIND and RIGHT functions I think

[junkforhr]

I have a sample below.

I have a string of text and what I'm after is to return the value "H" for the 1st entry below, but, ignoring the first 3 characters and for the 2nd entry return that value of "T",ignoring the 1st 3 characters.

I've tried combing the FIND and RIGHT functions without success.

Value	H	T
ABTpolHasdasdasd	H
POHpolTasdasdasd		T

 

[kevin9999]

Do you mean like this?

Book1
	A	B	C
1	Value	H	T
2	ABTpolHasdasdasd	H
3	POHpolTasdasdasd		T
Sheet2

Cell Formulas
Range	Formula
B2:C3	B2	=IFERROR(MID($A2,FIND(B$1,$A2,4),1),"")

 

[junkforhr]

Do you mean like this?

Book1
	A	B	C
1	Value	H	T
2	ABTpolHasdasdasd	H
3	POHpolTasdasdasd		T
Sheet2

Cell Formulas
Range	Formula
B2:C3	B2	=IFERROR(MID($A2,FIND(B$1,$A2,4),1),"")

Thanks Kevin,

This is exactly what I was after.

 

[kevin9999]

This is exactly what I was after.

Happy to help & thanks for the feedback

 

[Peter_SSs]

A variation ..

23 06 05.xlsm
	A	B	C
1	Value	H	T
2	ABTpolHasdasdasd	H
3	POHpolTasdasdasd		T
Sheet2

Cell Formulas
Range	Formula
B2:C3	B2	=MID($A2,FIND(B$1,$A2&B$1,4),1)