Home » Any Answers » Excel document query

Excel document query

Posted by kiwilondon99 PM | on Mon, 13/12/2010 - 09:14  657  5 comments | report

 

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 | Mon, 13/12/2010 - 10:34
Richard Willis's picture

Data: Text to Columns

stevie | Mon, 13/12/2010 - 13:10
stevie's picture

To Richard and Stevie

hossy2 | Tue, 14/12/2010 - 16:10

It probably will if the seperators are fullstops

ACDWebb | Tue, 14/12/2010 - 16:33
ACDWebb's picture

Try ...

JC | Tue, 14/12/2010 - 16:33