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

Peter

A merge of cell A1 and A2 will give the data in A1 only. You can go to another cell and enter
=VALUE(CONCATENATE(A1,A2))
to get the 14600 result.

Mark

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