<div>
Barry, your equation gives me the same txt string as mine. &nbsp;Still, the text string &quot;9/16/2011 6:05:07 PM&quot; refuses to be recognized as a date.<br />
<br />
But I figured out one way to skin this cat. &nbsp;I multiplied your formula times 1. &nbsp;Now it works.<br />
<br />
Thanks for your help.
</div>


Barry, your equation gives me the same txt string as mine.  Still, the text string "9/16/2011 6:05:07 PM" refuses to be recognized as a date.

But I figured out one way to skin this cat.  I multiplied your formula times 1.  Now it works.

Thanks for your help.

<div>
Multiply the solution formula x1 (times one), and now the text string is recognized as a date.
</div>


Multiply the solution formula x1 (times one), and now the text string is recognized as a date.

<div>
Sorry I didn't see the part that said &quot;I tried this formula but the result is not being recognized as a MS date/time&quot;, otherwise I would have suggested something similar (I usually add zero)<br />
<br />
regards, barry
</div>


Sorry I didn't see the part that said "I tried this formula but the result is not being recognized as a MS date/time", otherwise I would have suggested something similar (I usually add zero)

regards, barry

<div>
<div class="content wysiwyg-content">
What's the simplest way to extract the date &amp;&nbsp;time from the following text string:<br />
&quot;This document has been digitally Signed 9/16/2011 6:05:07 PM&quot;<br />
<br />
I tried this formula but the result is not being recognized as a MS date/time.<br />
=RIGHT(Rd_Reviewer2Sign,LE<wbr />N(Rd_Revie<wbr />wer2Sign)-<wbr />LEN(&quot;This document has been digitally Signed &quot;))<br />
<br />
A VBA solution would be best, but a worksheet function (llike I tried) will work.<br />
<br />
Thanks, --Andres
</div>
</div>


What's the simplest way to extract the date & time from the following text string:
"This document has been digitally Signed 9/16/2011 6:05:07 PM"

I tried this formula but the result is not being recognized as a MS date/time.
=RIGHT(Rd_Reviewer2Sign,LEN(Rd_Reviewer2Sign)-LEN("This document has been digitally Signed "))

A VBA solution would be best, but a worksheet function (llike I tried) will work.

Thanks, --Andres

Excel - Extract date from a text string

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.