How to Use Extract Dates From Text in Excel - Excel for Beginners - 11

[@RamonaHuerta-d2o]

Fantastic, THANK YOU!!

[@northshoreandmore]

This is amazing, thanks so much for posting.

[@AtifNaseem]

Our pleasure!

[@babarkhan3811]

👍👍👍great sir...

[@AtifNaseem]

My pleasure. Don't forget to like : )

[@Ha.studio187]

Very nice content 👍

[@AtifNaseem]

My pleasure. Don't forget to like : )

[@udini1]

Awesome. A question if I may - If I have a text such as : " Players_30002_20200718_Fire.txt " and the date is 18/07/2020 - How can I reach the result to show just the Date like that? with the help of your guide I've made it to : 20200718 - ( after filtering out the every other text ) but I cant change the format of the cell to a normal date. Anyway to achieve that?

[@AtifNaseem]

did you use TEXT() to change the format of the value? format of the cell to a normal date will change from "format cell" (right click the cell)

[@udini1]

@@AtifNaseem I'm trying =TEXT(D22,"MM/DD/YY") but in cell D22 I have: =SUBSTITUTE(D21,"_V1_2.txt","") - the the result I'm getting is #VALUE! error. - Trying to right click and format cells ( tried to test and change each of them, won't change the outcome )

[@Ha.studio187]

Thank you sir

[@AtifNaseem]

My pleasure. Don't forget to like : )