eg.xlsx

Hi Everyone,

I'm new to this forum; so please forgive if this query has already been answered.

As given in the attachment; I want help in multiplying only the numbers in the respective columns & the result to be displayed with a prefix in other column.

eg. entry in column A: 1.06mtr. X 50mtr.
entry in column B: R 12.50

required entry in column C: R 662.50 ('R' being the required prefix & 662.50 being the multiplication of the numbers.

Please guide me if this is possible.

Any help in this regard would be highly appreciable.

Regards,

Pallav