Dan B wrote:
This makes it look the way I want but I actually need them separated for
sorting purposes. Is there a formula that will do it. I tried to use
=right(a1,10) but it just have some numbers that didn't mean anything and
could not be formatted as time.
Any other ideas?


Hi Dan B

Try this:

Select the cells containing the data.

Click Data Text to Columns.

Click Delimited, click Next

Uncheck Tab, check Space, click Finish.

Regards

Steve