Forum Discussion

Copper Contributor

Jan 21, 2026

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 only?

Thanks a lot in advance.

excel

2 Replies

Harun24HR
Bronze Contributor
Jan 21, 2026
REGEXEXTRACT() or FILTERXML() may help. Post few of a sample data.
Lorenzo
Silver Contributor
Jan 21, 2026
Hi
For this kind of things you should share - say 10 to 20 representative & different - of your actual text values + the version of Excel you run & on which platform (Windows, Mac, Web...)