Formula help - Extract 10 characters after the first space to the left

[easybpw]

Hello,

Thanks in advance for the help. I'm trying to find a formula to extract the next 10 characters after the first space on the left. See below.

Discover 10/21/2021 Sale $9,250

I want the result to be 10/21/21. The cell containing Discover can change and is not the same # of characters. I can extract everything between spaces but the workbook I need to use doesn't always have a space after the date. Sometimes it just runs together. So I need to extract exactly 10 characters.

Thanks!

 

[JEC]

What about

=MID(A1,SEARCH(" ",A1)+1,10)