combining 3 columns into useable date
 

I am cleaning excel sheets for import into another program which needs dates
in one line eg 30/03/2006. Some of the worksheets I have contain date fields
over three columns:

Day Month Year
06 03 2003
21 05 1987
14 05 1990
21 05 1987

I need to combine them & add formatting eg, From line 1: 06/03/2003

Have visibly lost hair trying to use CONCATENATE, can someone point to an
simple solution?

combining 3 columns into useable date
 

=DATE(C2,B2,A2)

formatted as a date.

HTH,
Bernie
MS Excel MVP


"Rob B" wrote in message
...
I am cleaning excel sheets for import into another program which needs dates
in one line eg 30/03/2006. Some of the worksheets I have contain date fields
over three columns:

Day Month Year
06 03 2003
21 05 1987
14 05 1990
21 05 1987

I need to combine them & add formatting eg, From line 1: 06/03/2003

Have visibly lost hair trying to use CONCATENATE, can someone point to an
simple solution?

combining 3 columns into useable date
 

Hi Rob!

Have you tried using the DATE function?
--
-----------
HTH

NilsIvar



Rob B skrev:

I am cleaning excel sheets for import into another program which needs dates
in one line eg 30/03/2006. Some of the worksheets I have contain date fields
over three columns:

Day Month Year
06 03 2003
21 05 1987
14 05 1990
21 05 1987

I need to combine them & add formatting eg, From line 1: 06/03/2003

Have visibly lost hair trying to use CONCATENATE, can someone point to an
simple solution?

combining 3 columns into useable date
 

=date(c2,b2,a2)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Rob B" wrote in message
...
I am cleaning excel sheets for import into another program which needs
dates
in one line eg 30/03/2006. Some of the worksheets I have contain date
fields
over three columns:

Day Month Year
06 03 2003
21 05 1987
14 05 1990
21 05 1987

I need to combine them & add formatting eg, From line 1: 06/03/2003

Have visibly lost hair trying to use CONCATENATE, can someone point to an
simple solution?

combining 3 columns into useable date
 

Assuming your data is in range A2:C2, enter
=DATE(C2,B2,A2)
and format dd/mm/yyyy

HTH
--
AP
"Rob B" a écrit dans le message de
...
I am cleaning excel sheets for import into another program which needs
dates
in one line eg 30/03/2006. Some of the worksheets I have contain date
fields
over three columns:

Day Month Year
06 03 2003
21 05 1987
14 05 1990
21 05 1987

I need to combine them & add formatting eg, From line 1: 06/03/2003

Have visibly lost hair trying to use CONCATENATE, can someone point to an
simple solution?

combining 3 columns into useable date
 

Thank you very much for the instant answer, Most helpful

Cheers now, Rob.

"Bernie Deitrick" wrote:

=DATE(C2,B2,A2)

formatted as a date.

HTH,
Bernie
MS Excel MVP