Hey,
Ive just pulled aload of stuff out of a database, its all perfect but the dates come out like this...
02008-03-088 March 2008
I dont want to have to trim it all manually, is there a way I can make it delete all
#####-##-##
?
Hey,
Ive just pulled aload of stuff out of a database, its all perfect but the dates come out like this...
02008-03-088 March 2008
I dont want to have to trim it all manually, is there a way I can make it delete all
#####-##-##
?
With a formula perhaps
=MID(A1,FIND(" ",A1)+1,255)
Hello Steven
If all the column is in the same format/structure, then i think you'd be best off using Data>TextToColumns and using FixedWidth to specify how you want the data split. You can choose to skip import of the first column so you are simply left with your date (which I presume is 8 March 2008 in your example).
Richard
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks