Hello guys,
I recorded a macro which simply did Text to Columns on C14:C5000 using Space deliminator with Consecutive deliminator enabled. This works fine when I do it manually and copies to column D, but as soon as I run it in a macro it puts AM or PM in Column E?
Col C holds data like this '22/06/2014 07:30:00'
What I want:
Col C '22/06/2014'
Col D '07:30:00'
What I'm getting:
Col C '22/06/2014'
Col D '07:30:00'
Col E 'AM'
Macro script I'm using:
Any help is appreciated. ThanksPlease Login or Register to view this content.
Bookmarks