Extracting a date from text in a cell

**gedwards913** · 01-22-2015, 07:59 AM

Considering this is in L2, what would I use to pull the 01-21-15 from here in a dynamic method, as the 1.381 can be 0-4 decimals long?

L2's Text
0,"xxxxxxxx","0","0","0","0","0","0","0","0","0","0",0,"0",1.381,"01-21-15","08:42",0","0","0","0","0",*

Thanks!!!

**samba_ravi** · 01-22-2015, 08:04 AM

=MID(L2,SEARCH("??-??-??",L2),8)
try this

**gedwards913** · 01-22-2015, 08:08 AM

Perfect, Thanks!!

**samba_ravi** · 01-22-2015, 08:09 AM

you are welcome

Extracting a date from text in a cell

LinkBack

Thread Tools

Rate This Thread

Display

Extracting a date from text in a cell

Re: Extracting a date from text in a cell

Re: Extracting a date from text in a cell

Re: Extracting a date from text in a cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Extracting the date from a text string and then UN-reversing it...

Excel 2013 – need help extracting date and time from text cell plus more.

Extracting last date in text string

[SOLVED] Extracting numbers from text and converting into a date

Extracting a Date from a text string

Bookmarks

Bookmarks

Posting Permissions