| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenate a date and a # ID
I have two columns which I have to make into 1 for a chart label in order to
get the formatting of the two in the same direction. How can I concatenate (or ???) a date and a Text string into a single label? thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
concatenate a date and a # ID
Let's say your date is in A1 and the text is in A2
=text(A1,"mm-dd-yy")&" - "&A2 This returns "05-01-07 - whatever is in your text string" "BillO" wrote: I have two columns which I have to make into 1 for a chart label in order to get the formatting of the two in the same direction. How can I concatenate (or ???) a date and a Text string into a single label? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date concatenate? | Excel Worksheet Functions | |||
| Concatenate & Date | Excel Worksheet Functions | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
| Date CONCATENATE | Excel Worksheet Functions | |||
| concatenate text and date | Excel Discussion (Misc queries) | |||
Linear Mode
