Forum Discussion
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 ...
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...)
Thank you and sorry.
These are some of the texts in the column:
| invoice 2-10747 dated 12.2024.pdf |
| invoice 2-10846 dated 04.10.2024.pdf |
| invoice 2-11154 dated 12 December 2024.pdf |
| invoice 2-11196 dated 16 December 2024.pdf |
| invoice 2-11339 dated 29 January 2025.pdf |
| invoice 2-11427 dated 21 February 2025.pdf |
| invoice 2-11559 dated 31.03.2025.pdf |
| invoice 2-11567 dated 08 April 2025.pdf |
| invoice 2-11706 dated 13 May 2025.pdf |
| invoice 2-11928 dated 19 June 2025.pdf |
The problem is with the cells where the Month is shown as a name of the month instead as 03.2024, for example. This is Excel 365 for Windows. And in some cells the date is in the middle of the cell and not in the end.