Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
Concatenating Excel Cells Containing Dates And Text .
Posted by - NA - on 30 March 2006 06:27 AM
|
|
Solution: Suppose you'd like to combine two Excel cells. Let's say that cell A1 contains the text "Today's Date is," and cell D1 contains the date 12/31/01. Go to cell A4 and enter =a1&d1 then press Enter. What you'll get in cell A4 is "Today's Date is 37250." To concatenate a text cell and a date cell, you first have to convert the date to text. So go to cell A4 and type =a1&text(d1,"mm/dd/yy") then press Enter. Now cell A4 will display "Today's Date is 12/31/01." | |
|
Comments (0)