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

[@RamshaKhan-ud6ol]

Very helpful.. Thanks..

[@ExcelBasement]

Glad it was helpful!

[@karthikeyanmurthy273]

The video is really helpful.

[@malubamulebi5221]

Very helpful. This is the video I was looking for

[@ExcelBasement]

You are welcome 🤗

[@hema.r5689]

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

[@RamshaKhan-ud6ol]

Plzz

[@thehiddenhimachal4711]

I needed this badly .thank u

[@RamshaKhan-ud6ol]

Plzz share how can we extract dates if we have multiple dates in a sentence.

[@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))

[@tomaszlipinski8989]

wow Thank you :)

[@ExcelBasement]

Welcome!