Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top


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
Is the date always at the end? Is it always in the same format? – daxlerod Nov 12 '13 at 12:04

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


enter image description here

share|improve this answer
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .