Hi, can someone please help with vba code where i pull date and account # from cell and put it in another cell.

For example if in column C contains "DATE IS 10-10-2015, ACCOUNT# 123456789"
I would like just the date in another column and account in another column. Dates and Account are not always in the same order. it can be a mixture. I think i would require something where if the words "DATE IS" is found in cell then pull the date and if the word "Account" is found then take the account # and put them in respective column A and B. Thanks for help

Result should be
Column A Column B
10-10-2015 123456789