Concatenate and Multiply

T

tipoo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

concatenate and multiply problem 7
concatenate 2
Concatenate 2
Concantenate which keeps bold of some parts. 5
concatenate contents of cells whose contents resemble cell referem 3
IF 3
Merging cells and formats 8
concatenate values 4

Top