Recorded macro doing more than recorded?

[Trending]

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:

Please Login or Register  to view this content.

Any help is appreciated. Thanks

[Norie]

Are you running this on the same data and with the same cell(s) selected as you had when you recorded the macro?

Do you just want to separate the date and time?

[Trending]

Hi Norie,

That is correct. Same cells/data

[Trending]

Please Login or Register  to view this content.

I solved this by Text to Column using fixed width and formatting the columns to Date and Time

[Norie]

I tried a few variations but nothing worked, must have missed that one.

[Trending]

lol don't feel bad. It's had my head thumping for hours. Something that should be really simple turns into a pain.