Extract number data string from text

Hi,
My original data has 3 columns.
The first column contains text, some of which is the following:
Start Date/Time: 07/27/200822:26
Start Date/Time: 07/28/2008 00:23

The second column contains similar data to the first column, some of which is following:
Stop Date/Time: 07/27/200822:50
Stop Date/Time: 07/28/2008 01:23

I would like excel to extract properly formatted date value in the new columns.
To recap:
My original data:
Column 1

Stop Date/Time: 07/27/200822:26
Stop Date/Time: 07/28/2008 00:23

column 2
Start Date/Time: 07/27/200822:50
Start Date/Time: 07/28/2008 01:23

Modified spreadsheet:



Column 1
Start Date/Time: 07/27/200822:26
Start Date/Time: 07/28/2008 00:23

new column 1
7/27/2008 22:26
7/28/2008 00:23

column 2
Stop Date/Time: 07/27/200822:50
Stop Date/Time: 07/28/2008 01:23

New column 2
7/27/2008 22:50
7/28/2008 01:23

I would appreciate any help.
Thank you very much.

Try possibly:

=(MID(A2,FIND(":",A2)+2,10)&" "&RIGHT(A2,5))+0

where A2 contains string to convert...

you may need to format result as Date/Time...

Alternatively, if the lack of space between date & time in the example:

Start Date/Time: 07/27/200822:26

is a typo then you coudl run an Edit -> Replace over the data replacing:

What: Start Date/Time:
With: [nothing]

Repeat for "Stop" column.

The values should then coerce to date times.

I assumed it wasn't a typo..

Thank you very much, it worked!
I have another problem.
I import a lot of data from text files into Excel. Excel puts data in the single column.
I would like to separate the data into 3 columns based on the content.
I attached 2 files. One file that contains original data, another file shows an example how data should look like.
Thank you very much.