Hi,

I'm looking for a formula or something to help me to split a certain word in a cell or to return a certain word.

My example is:
Sandnesveien 19 M1020
M1020 Sandnesveien 19


I need to have the Mxxx in a different cell, which formula can I use to split it? In some cells the Mxxx is before the text and in some it is after.
Can someone help me?

Thanks in advance