Excel document query
i have had a 'database' created in excel ie rows + columns of data and lots of it !
one particular column of data has contents akin to : " 01.12.2010 city,state country " some of the cells are just the ' 01.12.2010 city, country' element only
i would like to split the date element from the location element - into 2 separate fields. and to then reformat the date into a usable field [ aim of the exercise is to be able to use the date portion ] the reformat of the date - i now know to do that bit