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?

=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?

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?

=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?

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?

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