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.

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.

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.

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.