Split Text & Date/Time string

[Darren Guess]

Hi

I have looked at a number of posts regarding splitting out date/time stings to separate cells, but I cannot find how to split the following.

I have the serviceable date of an aircraft delivery set as 'S hh:mm dd-mmm-yy', which is due to being used by an external application in this format. This is entered by the user and I need to be able to extract the date time strings and switch them to dd-mmm-yy hh:mm, excluding the S from the result as a formula in another cell.

I keep getting a #value error or returning the whole string result.

Thanks in advance
Darren

 

[Jonmo1]

Try

=RIGHT(A1,9)+MID(A1,3,5)

Format the cell with the formula in your desired date/time format.

 

[Darren Guess]

Perfect.

Many thanks for the quick reply. One to keep for reference.

 

[Jonmo1]

Glad to help, thanks for the feedback.