View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Concatenate and Multiply

see your other post

--
Biff
Microsoft Excel MVP


"tipoo" wrote in message
...
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