Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Example:

PROMOTED AS AO 2 W.E.F. 29.07.2010

This line is written in a single cell. I want to extract the date 29.07.2010 in another cell in Excel.

share|improve this question
2  
Is the date always at the end? Is it always in the same format? –  daxlerod Nov 12 '13 at 12:04

1 Answer 1

Your question lacks detail but assuming that the date is always on the right and remains in the same format (as in the last 10 characters or the cell) then you can use

=RIGHT(TRIM(A1),10)

enter image description here

share|improve this answer
1  
This just gives a text string, and presumably you want to do calculations with this date as well - in that case, you should use the VALUE function. Also, in my locale (UK), Excel didn't recognise dates formatted with a . separator, so I had to use SUBST to change the text to dd/mm/yyyy format. –  benshepherd Nov 13 '13 at 13:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.