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.
|