Originally Posted by Sir Humphrey Appleby
Is there a formula to take a date in a cell? I have a column of (lots of) deliveries but they're in the format of "Delivered - 31/08/2012" or "31/08/2012 - delivery to home address" etc. I want to make a column which would have cells with dates in.
Assumes data is going down Column A, starting with Row 2:
In Cell B2:
In Cell C2:
Which formula to use (and whether it goes in B2 or C2) will depend on whether the date is to the left or right of the letters.