Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Merge Cells and Keep Values of bothPosted 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
|Check out our Excel Resources
Re: Merge Cells and Keep Values of bothPosted 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.
Re: Merge Cells and Keep Values of bothPosted 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.