Want to convert this string 9/9/2013 22:00 to a proper YYYY-MM-DD hh:mm:ss format in Excel? Yeah, you can do that. It's easy!

=CONCAT(LEFT(RIGHT(B2, 10), 4), "-", RIGHT(CONCAT("00", LEFT(B2, FIND("/", B2) - 1)), 2), "-", RIGHT(CONCAT("00", LEFT(SUBSTITUTE(LEFT(B2,6),LEFT(B2,FIND("/",B2)),"",1),FIND("/",SUBSTITUTE(LEFT(B2,6),LEFT(B2,FIND("/",B2)),"",1)) - 1)), 2), " ", RIGHT(B2, 5), ":00")

Heaven forbid Microsoft actually create intelligent tools that let people solve problems. What about DATE() you ask? Nope. DATEVALUE()? Nope. You gotta do string manipulation 😑