merge two cell with text/data into one

C

Chamberlain

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?
 
P

Peo Sjoblom

=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?
 
A

Anderson Lee

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Cell data entering slow! 0
Drop down list control value in vba 2
Excel does not accept text format! 0
Page numbering with Merged Document and IF statements 1
Pasting a cell into bookmarked table from excel vba 1
Hyperlinks with lookups 0
countifs Function not giving desired result with date criteria 2

Top