Using vba to remove characters in columns

test.xls

Within this attachment I have three date columns in particular. Within those three date columns I need to remove the first 4 characters in each cell so I can then put the dd/mm/yy hh:mm format onto it.

What I'm struggling with is telling it to remove the leading 4 characters in cell N,O,P

Wed Oct 5 14:37:20 2011
Mon Oct 17 09:12:15 2011
Fri Oct 14 15:24:03 2011

I need to become

Oct 5 14:37:20 2011
Oct 17 09:12:15 2011
Oct 14 15:24:03 2011

the range can vary so putting a loop into the range so it goes down the column until it reaches last one with something like what ive listed below then telling it to remove first 4 characters in those cells without having any background formulas on the excel sheet.

Please Login or Register  to view this content.

Thanks K

I cant run an application.worksheetfunction then would be:

=MID(AD2,4,25)
to show me my desired results. any thoughts?

sorry for the late reply, exactly what I'm after watersev, thanks very much