How do I extract mm/dd/yyyy into separate columns Sneilan
D DDM Apr 23, 2004 #2 Sneilan, use the Text to Columns command on the Data menu. Delimited text, with / as the separator. Afterwards, format all cells as General. DDM "DDM's Microsoft Office Tips and Tricks" www.ddmcomputing.com
Sneilan, use the Text to Columns command on the Data menu. Delimited text, with / as the separator. Afterwards, format all cells as General. DDM "DDM's Microsoft Office Tips and Tricks" www.ddmcomputing.com
M Mike Apr 23, 2004 #3 Sneilan, If A1 = mm/dd/yyyy, then use the following formulas in other cells B1 = MONTH(A1) C1 = DAY(A1) D1 = YEAR(A1) Mike
Sneilan, If A1 = mm/dd/yyyy, then use the following formulas in other cells B1 = MONTH(A1) C1 = DAY(A1) D1 = YEAR(A1) Mike
