I am using Excel 2010 and have multiple rows containing the date and time merged together in one column.
I am trying to split the date and time to separate cells and also change the format of the date to mm/dd/yyyy and time to
hh:mm AM / PM but having some challenge. Any info is greatly appreciated.
Below are sample values *note the space between date and time, but the time values do not have a consistent number of characters*