Forum Discussion
SDj1
Jan 21, 2026Copper Contributor
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 ...
John Gruber
Jan 22, 2026Brass Contributor
=REGEXEXTRACT(A1, "\d{2}\.\d{4}")