datetime - Converting "January 5th" and "February 1st" to dates (removing ordinals/th/rd/st) -


i have ~100 rows of live data website this:

january 24th 12:30pm ninja party

january 31st 3:30pm classic party

how can google sheets recognize dates? doesn't recognize ordinal endings (e.g. th/st/rd).

thank you.

this formula might work want (amend a2:a range required):

=arrayformula(if(a2:a="",,(iferror(datevalue(left(a2:a,search(" ",a2:a)+2)),datevalue(left(a2:a,search(" ",a2:a)+1))))))


Comments