Extract Date From File names

[Kavya132017]

I have multiple excel sheets with same file name format, I want to extract just the date part from it and keep it in a new column.

Data:

Full Data View 9-5-2023 10-15-48 AM

Full Data View 10-5-2023 10-15-48 PM

Full Data View 9-25-2023 10-15-48 AM

Output required: 9-5-2023, 10-5-2023, 9-25-2023

[Deano478 · Accepted solution]

@Kavya132017 you can do that like this:

[binuacs]

@Kavya132017 one way using regex