Count frequency of a numerical value in a cell

[Kara_xy]

Hi,

Is there any way I can count the frequency of an numerical value in a cell? For example I have the following data in a single cell.
09/04/2009 - Client Office
15/04/2009 - Client Office
29/06/2009 - Lunch + Client Office
How can I count the number of time that 2009 appears?

Thanks in advance for any help.

[windknife]

If your data at A1,

B1
=(LEN(A1)-LEN(SUBSTITUTE(A1,"2009","")))/LEN("2009")

HTH,
windknife

[Kara_xy]

I tried it out my file, but it is unable to work. Attached is a sample of the file I am working on, can you please tell me where do I went wrong?

[windknife]

Your data is in a range.
Try this,

L3

Please Login or Register  to view this content.

Committed with Ctrl+Shift+Enter
copied down.

You can also see attached file.
Hope this helps,
windknife