Solved: generate a Code from Column A and B

[parscon]

Dear friends

I have Some numbers in Column A and also some string text in Column B

Like this :

Column A

A1 : 265162
A2 : 12432365
A3 : 3224533
A4 : 4633357

Column B

B1: Tom hanks
B2: Samsung Galexy S4
B3: Apple Iphone 4S
B4: Mac

Now I need a VB code that generate a Code with the five charset of column A from right to left (that mean for A1 will be : 65162 or for A2 : 32365) and for Column B : the first of each word that mean for column B1 will be : Th and for B2: SGS and for B3: AI4 and for B4:M and put them in column C

Also add - between data on column A and B

like

C1 : Th-65162
C2 : SGS-32365
C3 : AI4-24533
C4 : M-33357


Also I attach the sample file enclosed this post .

Thank you very much for your kind and help .