Hi All,
I wonder if anyone can help?
I have a workbook that contains a date in a text cell and I would like to create a function to extract the date, I would also like to format the cell as a date after the information has been extracted.
Oh and I forgot to mention that not all the cells have text so would it be possible to ignore the cell that are blank?
Below is an example of the text in the cell with the date: -
<colgroup><col width="387"></colgroup><tbody>
</tbody>
I wonder if anyone can help?
I have a workbook that contains a date in a text cell and I would like to create a function to extract the date, I would also like to format the cell as a date after the information has been extracted.
Oh and I forgot to mention that not all the cells have text so would it be possible to ignore the cell that are blank?
Below is an example of the text in the cell with the date: -
Payment# 328604 on 09/14/18 for GBP 231.00 Thank you for looking and I would be really grateful for any help. |
<colgroup><col width="387"></colgroup><tbody>
</tbody>