Please elaborate and clarify what exactly you would want to extract from the example texts in your post.

Thank you Riny..

I need to extract the name of the month out of a long text in order to use it for further analysis. And I need this to be by using power Query.
I attached an example.

Many thanks.

Thanks for the file. If the texts are really as straight-forward as in your example, the easiest way would be to first extract everything before " 2024". Then, the month name can be extracted based on what comes after the first space as seen from the end. See attached.

If your real data isn't that simplistic, please upload a file with realistic texts.

Thank you so much Riny, I shall give it a try and might revert back if I need support.

thanks