How to extract values between different caracteres ?

[Inacio11]

Hi.
At link below I have attached a excel file where I am trying to extract the data number (day-month-year) from 3 different texts and with different lenghts, but with no sucess till now. I have included more details on excel file.
I need the formula (not VBA) !
https://www.sendspace.com/file/c6s2ji
Thanks in advance !
Inacio

 

[Inacio11]

Hi again !
Thanks for you support !

Yeah ! It works when I make the changes as you said.
The problem is I receive the "text as it is" by SMS, so it is no feasible to change manually everytime.

 

[jtakw]

So your region uses dd mmmm, yyyy format?

 

[Inacio11]

Yes! I'm from Brazil

 

[jtakw]

Try these updated formulas and see if they work for you, it's hard for me to test 100%, as I'm in USA.

Book1
	C	D	E	F	G
4			day	month	year
5	SMS from: 88888 2018-07-02 10:59:27		2	7	2018
6	From 27300 July 02, 2018 at 0721PM		2	7	2018
7	From 11108 July 02, 2018 at 1017PM		2	7	2018
8	SMS from: 888889 2017-08-25 10:59:27		25	8	2017
9	From 273009 July 04, 2018 at 0721PM		4	7	2018
10	From 111089 January 31, 2015 at 1017PM		31	1	2015
Sheet122

Cell Formulas
Range	Formula
E5	=DAY(TEXT(LEFT(SUBSTITUTE(TRIM(MID($C5,MIN(FIND({0,1,2,3,4,5,6,7,8,9},$C5&"0123456789"))+6,255))," ",REPT(" ",50),IF(ISNUMBER(FIND(",",$C5)),3,1)),50),"mmmm dd, yyyy")+0)
F5	=MONTH(TEXT(LEFT(SUBSTITUTE(TRIM(MID($C5,MIN(FIND({0,1,2,3,4,5,6,7,8,9},$C5&"0123456789"))+6,255))," ",REPT(" ",50),IF(ISNUMBER(FIND(",",$C5)),3,1)),50),"mmmm dd, yyyy")+0)
G5	=YEAR(TEXT(LEFT(SUBSTITUTE(TRIM(MID($C5,MIN(FIND({0,1,2,3,4,5,6,7,8,9},$C5&"0123456789"))+6,255))," ",REPT(" ",50),IF(ISNUMBER(FIND(",",$C5)),3,1)),50),"mmmm dd, yyyy")+0)

 

[Inacio11]

OK ! Thanks again !

 

[jtakw]

You're welcome, does that mean it worked for you?

 

[Inacio11]

Not yet exactly.....but you already gave me the "way". Now I'm working on a Excel in english, but I will test on my excel with local settings...if something goes wrong...I will ask again ! Thanks

 

[jtakw]

Ok, Good Luck, BTW, Welcome to the forum.