Try this...

=--(A1&" "&B1&", "&C1)

--
Rick (MVP - Excel)


"sweetthing4luc" wrote in message
...
I have an excel formula question. I need to do the following and I am
unsure
how to do it. I have three columns that represent a birthday, in column
one
I have the month spelled out, in column two I have the date of birth and
in
the third column I have the year. In the forth column that I will create,
I
need to have the date of birth together as such mm/dd/yyyy. Unfortunately
there are thousands of entries this way and I want to find one simple
function that can convert these entries into one item. If you have the
solution please let me know. Thank you so much.