How do i parse a text string with a date?
 

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.

How do i parse a text string with a date?
 

have a look at =TRIM(A6) this removes spaces at the start & end of a
string


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=551296