excel - VB script to copy the last digits of a columnA data and paste it as a suffix to the data in columnB -

i need vb script, can copy last 2 digits column , paste same suffix data available in column b.

ex: columna 40011.03 columnb product_revenue

result should columna 40011.03 columnb product_revenue.03

asking help, i'm new scripting.

thanks in advance help.

you can use formula achieve this...

=b1&"."&mid(a1,len(a1)-2,len(a1))