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

many thanks

Comments
There are 5 comments. Login or register to view them.

ASSUMING that the date is seperated from the rest by a space (al

Richard Willis |
Richard Willis's picture

Data: Text to Columns

stevie |
stevie's picture

To Richard and Stevie

hossy2 |

It probably will if the seperators are fullstops

ACDWebb |
ACDWebb's picture

Try ...

JC |