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:
Range("C14:C5000").Select
Selection.TextToColumns Destination:=Range("C14"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=True, Other:=False, OtherChar:=False, _
FieldInfo:=Array(Array(1, 1), Array(2, 1)), TrailingMinusNumbers:=True
Any help is appreciated. Thanks
Bookmarks