Thread: concatenate and multiply problem
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 problem
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
Reply With QuoteReply With Quote