letter hook front and back

I have this on a1 b1 and c1 downwards

AURA l elrs
VARA ns
RAYA hs
ALMA ht hs
AMLA s
LAMA lu s

I need results as follows

AURA l elrs L
VARA ns
RAYA hs
ALMA ht hs H
AMLA s
LAMA lu s

I need the formula to find common letter hook existing as front and back , example ALMA has HT as front and HS back , the common is H

Works very well it pulled as follows on A

BAND a ahsy A
CHAR a adekmrsty A
DOWN a asy A
LONG afkp aes 2019 A
LOOF ak as 3906 A
MASS a aey A
MENT a ao A
MISS a ay A
PORT as asy A
SPIC a aeksy A

https://www.excelforum.com/excel-for...ck-search.html

Canapone , maybe you can also try another thread of mine , attached above