Forum Discussion
Solved
Extract mm.yyyy from text
Hello, I have a column with text with different length, which contains month and year in a format mm.yyyy and it could be located at a different place within the cell. How can I extract the mm.yyyy ...
=REGEXEXTRACT(A1, "\d{2}\.\d{4}")
REGEXEXTRACT() or FILTERXML() may help. Post few of a sample data.