If there is never any digit in the string before the date substring at
the end:

=REPLACE(A2,1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A2& "0123456789"))-1,"")+0

wrote:
Hi,

How would I grab the date out of a string where the date text is
located at the end of the string? The string is of variable length. IE

"I need your help 2 jun 2006"
"I have no idea what I'm doing 2 jun 2006"

I'll need to convert the date string into a integer date value.
Thanks for your help