Extract Dates from Text - Column from Examples (POWER QUERY) - Microsoft Excel

Extract Dates from Text - Column from Examples (POWER QUERY)
#PowerQuery #Dates

[@karthikeyanmurthy273]

The video is really helpful.

[@hema.r5689]

Thanks for the video, Pls let us know how to extract single cell containing multiple dates.

[@malubamulebi5221]

Very helpful. This is the video I was looking for

[@ExcelBasement]

You are welcome 🤗

[@thehiddenhimachal4711]

I needed this badly .thank u

[@tomaszlipinski8989]

wow Thank you :)

[@ExcelBasement]

Welcome!

[@dhavalpatel8175]

I have an excel sheet like this::::
___________________________________________________________________
in the first cell: 1:08:00 AM
in the second cell: TEXT
in the third cell: 1:15:00 AM
in the fourth cell: TEXT
in the fifth cell: 1:20:00 AM
in the sixth cell: TEXT..........................and so on till 800 rows like this.
___________________________________________________________________
now I have 800 rows like this. How can I remove only time value 1:08:00 AM from all 800 rows so that I can extract only TEXT values.

[@ExcelBasement]

If you are using Excel 365
Example: =FILTER(B3:B8,ISTEXT(B3:B8))