Hey Guys
quick one (hopefully
).
I have a cell that contains multiple text entries. I would like to find dates within that cell. I've partially solved it however I can only find the first date. For example:
currently the formula I have finds the first date by search for the word review and then counting the places after it, which is great if the dates are the same but if they are different I'm not sure how to loop it through the cell.
The formula i'm using is
which puts the date into a cell which I then call later on using VBA.
Any help gratefully received, TIA
quick one (hopefully
).I have a cell that contains multiple text entries. I would like to find dates within that cell. I've partially solved it however I can only find the first date. For example:
currently the formula I have finds the first date by search for the word review and then counting the places after it, which is great if the dates are the same but if they are different I'm not sure how to loop it through the cell.
The formula i'm using is
Code:
=IFERROR(CLEAN(TRIM(MID(F5,(FIND("review",F5)+6),10))),"No Date Found")Any help gratefully received, TIA
