Forum Discussion

SDj1's avatar
SDj1
Copper Contributor
Jan 21, 2026
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 ...
excel
  • John Gruber's avatar
    John Gruber
    Jan 22, 2026

    =REGEXEXTRACT(A1, "\d{2}\.\d{4}")

IlirU-1734's avatar
IlirU-1734
Copper Contributor
Jan 23, 2026

Hi,

I used this formula in cell C2:

=--SUBSTITUTE(TEXTBEFORE(TEXTAFTER(A2:A11, "dated "), ".pdf"), ".", "/")

I have formatted the cells in column C as dates, so mm.yyyy

If you want your data to appear as text then use this formula:

=TEXT(SUBSTITUTE(TEXTBEFORE(TEXTAFTER(A2:A11, "dated "), ".pdf"), ".", "/"), "mm.yyyy")

Hope this helps.

IlirU