How to parse a string with a date?

  • Thread starter Thread starter powderwoo
  • Start date Start date
P

powderwoo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do i parse a text string with a date? 1
How do I grab the date from a text string? 4
Formula with DateValue and doing Fill doesn't work, need help 2
Lookup date between 2 dates 1
Excel 2003: Count how many times a date occurs 4
2 criterias in lookup 1
How to set the value to zero if it negative after the substract 5
Parse cell contents to new columns 6

Back
Top