Hi,
Thanks for the help in advance.
I have several cells with the date located at the end. However there
are spaces at the end of the string of variable unknown length usually
anywhere from 5-15 spaces. For example the string in quotes are
"I need your help 12 JUN 2006 "
"Thanks for your help 12 JUN 2006 "
Someone earlier suggested using
=Datevalue((Right((Cell#),11)))
However this only works if the spaces were not there.
Thank you.
Bookmarks