View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob B
 
Posts: n/a
Default 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?