Converting a text string date+time

Hello, I'm looking for a way to convert a text string into a format that Excel recognizes as date+time. Excel version used is 14.0.7177.5000 (32 bit) Italian localization, part of Office 2010

My source text format is like this inside a single cell

Feb 15, 2017 3:01:01 PM

I need to convert into anything that is recognized as date + time in a single cell (should be in a single cell because I'll use these dates to plot data into a chart)

I have tried a number of options

• Changing cell format from text to date (or to time), but the source text string is not interpreted and the output is not treated as date+hour
• Sorting day-month-year-hour with a series of MID() and CONCATENATE() functions, but the output is still not recognized as date-hour. Used formula was =MID(A1,5,2)&CONCATENATE("/")&MID(A1,1,3)&CONCATENATE("/")&MID(A1,9,4)&CONCATENATE(" ")&MID(A1,14,15) where A1 is a cell containing the source text
• DATEVALUE() formula: only manages dates without time
• TIMEVALUE() formula: only manages hours, even if the final formatting includes dates, the formula ignores anything in the input that is not an hour (as stated in the Excel documentation)

Thank you in advance for any idea and help you may provide

•DATEVALUE() formula: only manages dates without time
•TIMEVALUE() formula: only manages hours, even if the final formatting includes dates, the formula ignores anything in the input that is not an hour (as stated in the Excel documentation)

Did you try: DATEVALUE() formula + TIMEVALUE() formula

Indi_Ra, your idea works great! I didn't think of combining the 2 formulas. Thank you!