Isolating text within a string with no post text (certain number of characters)

[Helloitsme]

I want to isolate the "EF" with the following 6 numbers (always 6 numbers, sometimes with space between). I have replaced "EF" with "-EF" so I have a prefix to these, but can't seem to just isolate the 8 character string, without having the post text or some numbers deleted. Does anyone know what could be wrong?

I'm using the following formula, C1 being the text on the right:
=IFERROR(MID(C1;SEARCH("-EF";C1)+1;SEARCH(" ";C1;SEARCH(" ";C1)+1)-SEARCH(" ";C1)-1);"")

 

[Fluff]

How about

=IFERROR(MID(C1;SEARCH("-EF";C1)+1;8);"")

 

[Helloitsme]

How about

=IFERROR(MID(C1;SEARCH("-EF";C1)+1;8);"")

Works very close like a charm. There's an issue with inputs like "EF 16 90 14", where just "EF 16 90" is in the output. Do you know of a work around for this?

Thanks for the help!

 

[Fluff]

Try

=IFERROR(MID(SUBSTITUTE(C1;" ";"");SEARCH("-EF";SUBSTITUTE(C1;" ";""))+1;8);"")

 

[Helloitsme]

Try

=IFERROR(MID(SUBSTITUTE(C1;" ";"");SEARCH("-EF";SUBSTITUTE(C1;" ";""))+1;8);"")

Absolutely beautiful. Thank you so much! Never would've figured that out myself.

 

[Fluff]

You're welcome & thanks for the feedback.