scrabble hook macro

[makinmomb]

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

[makinmomb]

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

[mike7952]

Looking at your worksheet and your 2 post describing what your trying to do I have no idea of what it is you are trying to do. Can you explain in more detail?

[kasan]

Try this code for first column.

Please Login or Register  to view this content.

[makinmomb]

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

[kasan]

Just add this signes (in red)

Please Login or Register  to view this content.

[makinmomb]

Thank you so very much