How to implement search and selection of values ​​by pattern in Excel?

Question

excel

Good afternoon.
There is a line like (individual columns are marked with | ):
| Ivanov Ivan | 04.10.2012 birthday | Ivanov | Ivan | 9221112211 | Ivan |
You need to do an automatic search in this line for a value that looks like "04.10.2012" (2 digits dot 2 digits dot 4 digits) and write this value in a separate column in the same line.
Tell me in which direction to dig, maybe there are functions or several functions with which you can implement this, or you still have to write a macro in VBA.
If possible, I would like some example.

Answer 1

If you pervert specifically with formulas without VBA, then this: searches in the first 3 cells, then change by analogy.
=ПСТР(A1&B1&C1;ПОИСК("??.??.????";A1&B1&C1;1);10)

Answer 2

The advanced filter www.planetaexcel.ru/techniques/2/197 will help you . You need to carefully look at the criteria table and, based on it, write =*??.??.????* in the cell, then it will search for any values ​​in this format, try it. The main thing is that it automatically copies the data to a new table.
I managed to solve similar problems with his help, I hope it will help you.