index first charakter left or right of partial string from list of strings

[s@skia]

Hello, Excel Community
I have a problem which is probably somehow solvable with INDEX MATCH TRIM RIGHT and LEFT but I canīt get it to work at all.
In Table 1 I have strings and a column of unique identifyers like first row in both table below.
In Table 2 I have parts of the these string with the matching identifyers like asdn
now i want to get the characters adjacent to the partial string of table 2 form the string in table 1
as filled out in two next columns BOLD
with some exceptiosn like End and Beginning as well as ignoring spaces as shown in the examples.


Table1: identifyer_ string
adkjk Dynamic approach of testing for structural and
asdn functional characteristics of banana peel
ungbh and their dependencies which
angdu ultimately change the efficacy of
dugna banana peeling techniques, and a peel guide

Table2: identifyer_ partial string_ Left of Sring ? _ Right of String ?
asdn function Beginning a
ungbh s which e End
angdu change y t
dugna banana Beginning p
adkjk oach of r t
angdu mately i c
ungbh and their dependencies which Beginning End
dugna a peel n/d i/g

as you can see the example in the last row has two possible solutions (marked BOLD) I am not shure if that is even possible just with formulas but a starting point managing the other rows would still be appreciated.
The table might look bad, I tried to align the columns with space and tab as best I could which didnīt really work but the xlsx is also attached. There was one space missing in the partial string of last example [a_peel] changed it in the post but not in attachement, sorry for the inconvenience.
Thank you for your assistance.
SAS

[Alex H]

Hi SAS,

Adding a helper column to do the matching makes it easier when pulling out beginning and end characters.

See attached:Mappe1_ah.xlsx

My solution is admittedly a bit convoluted and does not deal with multiple solutions but I hope it's a helpful start.

My question is why are you trying to do this?!

[s@skia]

I want to use this as part of a string comparsion where In the end I want to evaluate and filter for a specific kind of string e.g not/all starting before one specific letter or correlations between all the partial strings showing the beginning of a scentence in the list of strings (which are sentences) compared to distinct speaking patterns represented by the list of partial strings after read by peple and acoustically evaluated.

[s@skia]

And thank you! It works with the first part exactly.
I guess sorting out multiple solutions is only possible using a more complicated vba script, Iīll try to solve it but will probably end up posting a similar question in the Macro/VBA section sooner or later.