MrExcel Consulting
Your One Stop for Excel Tips & Solutions

Merge Cells and Keep Values of both

Posted by Peter Munro on April 18, 2000 8:44 AM

How would I merge two cells and simply combine the values into one number?

Eg. Cell A1: 14, Cell A2: 600 Cell: A3 (should read: 14600

Thank you.

Posted by Mark on April 18, 2000 10:26 AM


A merge of cell A1 and A2 will give the data in A1 only. You can go to another cell and enter
to get the 14600 result.


Posted by Dave Stimpson on April 18, 2000 1:19 PM

Instead of the concatenate command you could use & instead
=A1&B1 would create 14600 as text
=value(a1&b1)would create it as a number