Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

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.


Check out our Excel Resources

Re: Merge Cells and Keep Values of both

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


Re: Merge Cells and Keep Values of both

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.