Concatenate

M

Mac8128

How can I concatenate three cells each with a number so that the concatenated
cell is a number, not text?

Example
A1 B1 C1 D1 (concatenated)
19 21 133 1921133
 

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

How to pass variables as arguments of a function 1
concatenate 2
Concatenate with the formula values 2
Trouble with concatenation number format 2
Concatenate With Criteria 5
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Concatenation in Excel 2003 7
Constructing Range Name calls with Concatenate 4

Top