I have text below and am trying to extract the first date in B3 i.e 15 June 2015 and the second date in C3 i.e . 20 June 2015
It would be appreciated if someone could kindly assist me
It would be appreciated if someone could kindly assist me
Excel 2012 | ||||
---|---|---|---|---|
A | B | |||
3 | David Martins - CT-BKT return 15 June 2015 - 20 June 2015 | June 2015 - 20 June 2015 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B3 | =RIGHT(A3,FIND("return",A3)) |