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
VBA Coding Help for Beginner 0
Date diffrence in days, weeks and months. 1
concatenate 2
Help needed regarding calculating time 0
Merging cells and formats 8
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
If, Or, and 5

Top