Extracting lines starting with a certain number in a cell.

Hello.

I have an issue that i need some help sorting out

I have several excel documents containing cells with many lines within one cell. each of these lines have a special formatting. like this:

1

text

123456.654321: Some text {some link} 987654.456789: some more text {another link} 987654.456789: some more text {another link} 222222.111111: some more text {another link} 222222.111111: some more text {another link} 123456.654321: Some text {some link}

So what i want to do is to extract all lines starting with 222222. Or remove all that start with something different than 222222.
I have managed to extract the first line in the cell using MID formula, but i am struggling with getting all of them since there are many cases within one cell.
I have used this formula:
=MID(C2; FIND("248848";C2);LEN(LEFT(C2;(FIND("}";C2;1)-11))))


Thanks in advance.

Glenn Kennedy
Thanks for the response.
Not fully, it seems to only extract the first out of the two. i need it to extract both and result in the same cell (same kind of format as originally minus the ones not starting with 222222)

I got it working now! :D Was not familiar with the CSE formulas. No good reason to not use XLSX. Just a bad choice of extension when doing my export from database
Thank you so much! you really saved me a lot of time and hassle :D