Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate a date and name
Each time I try to concatenate a date cell (ex 03/01/09) with a name file (ex
Johnson) the formul puts the date into its digital representative along with the name (in the ex the result is 39508 Johnson). Is it even possible to combine the two files? Any assistance would be greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate a date and name
You can use the TEXT function to do this. Let's say your date is in cell A1
and your name is in cell B1. Use this formula: =TEXT(A1,"mm/dd/yy")&" "&B1 HTH Elkar "rd251" wrote: Each time I try to concatenate a date cell (ex 03/01/09) with a name file (ex Johnson) the formul puts the date into its digital representative along with the name (in the ex the result is 39508 Johnson). Is it even possible to combine the two files? Any assistance would be greatly appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate a date and name
=TEXT(A2,"mm/dd/yy ")&B2
-- __________________________________ HTH Bob "rd251" wrote in message ... Each time I try to concatenate a date cell (ex 03/01/09) with a name file (ex Johnson) the formul puts the date into its digital representative along with the name (in the ex the result is 39508 Johnson). Is it even possible to combine the two files? Any assistance would be greatly appreciated. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate a date and name
What do you want to do with the date and name. I am a bit confused by your
description but I get the feeling that you want to use it as a file name. Is this correct? The forward slash that is the delimiter in the dates in the previous posts cannot be used in a file name. Use date format like mm dd yyyy or some other format that has acceptable characters for the file name. Also consider reversing the dateformat to yyyy mm dd format and if it is the first part of the file name then you can use it to index the filenames. -- Regards, OssieMac "rd251" wrote: Each time I try to concatenate a date cell (ex 03/01/09) with a name file (ex Johnson) the formul puts the date into its digital representative along with the name (in the ex the result is 39508 Johnson). Is it even possible to combine the two files? Any assistance would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate a date and a # ID | Excel Worksheet Functions | |||
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 |