ExcelBanter - Concatenate and Multiply

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Concatenate and Multiply (https://www.excelbanter.com/excel-worksheet-functions/240111-concatenate-multiply.html)

tipoo

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

T. Valko

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

All times are GMT +1. The time now is 03:56 PM.