View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tipoo tipoo is offline
external usenet poster
 
Posts: 15
Default Concatenate and Multiply

Hi,

Please ignore my previous post. This is the correct one.

A B C D
Island 2 3 4

Is it possible to first multiply digits in cell B1,C1 and D1 and then
concatenate text in cell A1. Also I want to apply formula in A1. I want to
see something like this in cell A1:

Island 24