merge two cell with text/data into one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to merge data from two cells into one cell. For instance, cell A2 has 5/31/03, cell B2 has "cd case", and in cell C2 I would like "cd case 5/31/03". Is there a formula for this?
 
=C2&" "&TEXT(A2,"mm/dd/yy")

--

Regards,

Peo Sjoblom


Chamberlain said:
I would like to merge data from two cells into one cell. For instance,
Click to expand...
cell A2 has 5/31/03, cell B2 has "cd case", and in cell C2 I would like "cd
case 5/31/03". Is there a formula for this?
 
You could use third party tool to safety merge selected cells with with
keeping all of multiple data values and unmerge cells with automatic dividing
multiple data values into several cells. You could download this software
from http://www.addintools.com.
 
Back
Top