Try this:

=A1&" "&PRODUCT(B2:C2,D4)

--
Biff
Microsoft Excel MVP


"tipoo" wrote in message
...
Hi,

A B C D
Island 2 3 4

Is it possible to first multiply digits in cell B2,C2 and D4 and then
concatenate text in cell A1. Also I want to apply formula in A2. I want to
see something like this in cell A1:

Island 24