software

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:

DayMonthYear
06032003
21051987
14051990
21051987

I need to combine them amp; 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 MVPquot;Rob Bquot; gt; wrote in message
...
gt;I am cleaning excel sheets for import into another program which needs dates
gt; in one line eg 30/03/2006. Some of the worksheets I have contain date fields
gt; over three columns:
gt;
gt; Day Month Year
gt; 06 03 2003
gt; 21 05 1987
gt; 14 05 1990
gt; 21 05 1987
gt;
gt; I need to combine them amp; add formatting eg, From line 1: 06/03/2003
gt;
gt; Have visibly lost hair trying to use CONCATENATE, can someone point to an
gt; simple solution?
Hi Rob!

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

NilsIvar
Rob B skrev:

gt; I am cleaning excel sheets for import into another program which needs dates
gt; in one line eg 30/03/2006. Some of the worksheets I have contain date fields
gt; over three columns:
gt;
gt; DayMonthYear
gt; 06032003
gt; 21051987
gt; 14051990
gt; 21051987
gt;
gt; I need to combine them amp; add formatting eg, From line 1: 06/03/2003
gt;
gt; Have visibly lost hair trying to use CONCATENATE, can someone point to an
gt; simple solution?

=date(c2,b2,a2)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Rob Bquot; gt; wrote in message
...
gt; I am cleaning excel sheets for import into another program which needs
dates
gt; in one line eg 30/03/2006. Some of the worksheets I have contain date
fields
gt; over three columns:
gt;
gt; Day Month Year
gt; 06 03 2003
gt; 21 05 1987
gt; 14 05 1990
gt; 21 05 1987
gt;
gt; I need to combine them amp; add formatting eg, From line 1: 06/03/2003
gt;
gt; Have visibly lost hair trying to use CONCATENATE, can someone point to an
gt; simple solution?
Assuming your data is in range A2:C2, enter
=DATE(C2,B2,A2)
and format dd/mm/yyyy

HTH
--
AP
quot;Rob Bquot; gt; a écrit dans le message de
...
gt; I am cleaning excel sheets for import into another program which needs
dates
gt; in one line eg 30/03/2006. Some of the worksheets I have contain date
fields
gt; over three columns:
gt;
gt; Day Month Year
gt; 06 03 2003
gt; 21 05 1987
gt; 14 05 1990
gt; 21 05 1987
gt;
gt; I need to combine them amp; add formatting eg, From line 1: 06/03/2003
gt;
gt; Have visibly lost hair trying to use CONCATENATE, can someone point to an
gt; simple solution?
Thank you very much for the instant answer, Most helpful

Cheers now, Rob.

quot;Bernie Deitrickquot; wrote:

gt; =DATE(C2,B2,A2)
gt;
gt; formatted as a date.
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP