scrabble hook macro

Find attached file

I have done manually on column i results of a word combining with letters on B as front hook and C as back hook
Example

ABA bcy cs

ABAB
ABAC
ABAY
CABA
YABA

I want the macro to do me this for all words on column A

Its telling the macro do form words ABA+B then ABA+C then ABA+Y the C+ABA the S+ABA

Try this code for first column.

Please Login or Register  to view this content.

Kasan works so beautifully , I need an extra favour to further develop the program to stage 2
This should close the loop of the macro as SOLVED

I want the results in format as below , an addition with sign

ABA-B
ABA-C
ABA-Y
C-ABA
S-ABA

Just add this signes (in red)

Please Login or Register  to view this content.

Thank you so very much