concatenate and multiply problem
Thanks heaps guys
"L. Howard Kittle" wrote:
No you can't do that. If you have "Island" in cell A1 and you try to enter
the formula into cell A1, it will displace the word "Island" and the formula
will be the sole occupant of A1.
You could enter this in A1 and it will return "Island 24".
="Island"&" "&PRODUCT(B2:D2)
Howard
"tipoo" wrote in message
...
Hi Howard,
Thanks but is it possible to use this formula in cell A1 which basically
means the value that you are concatenating is in the cell (A1)where you
are
applying the formula?
"L. Howard Kittle" wrote:
If I understand correctly, try this in A1.
=A2&" "&B2*C2*D2
HTH
Regards,
Howard
"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
|