Hi All,

I have a spreadsheet where one cell has the date and time i.e 23/11/2014 13:00:00,

I set up a VBA to split this (using text to columns) which worked the first time when recording the initial macro splitting the information into two cells one with the date and one with time time, however when this is run from the developer tab for further instances it now splits the cell into 3 columns (date, time and AM or PM).

I do not need the am or pm column can anybody help?