View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default concatenate and multiply problem

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