Search for Blanks in cell

[Archijs]

I have the folowing problem. I have a cell which contains text and somewhere within that text is a reference number. The reference numbers look like this:
ZBR-0001
ZMR-0002 etc.

I want to exract thar number in another cell. At first i was using the following formula: =MID(A1,FIND("-",A1)-3,8) and it seemed to work fine.

The problem i encountered was that some of the reference numbers might be up to 10 symbols and would look like this:

ZMZ-0003.1
ZNS-0004.2 etc.


I want to know if i can use the same formula that i had only in stead of "8", i would like to have something that indicated the number of characters until the next blank symbol.

I hope i made it clear enough

 

[Archijs]

Forgot to mention that i was considering using something like this to get the desired result:

=IF(MID(H96,FIND("-",H74)+5,1)=".",MID(H96,FIND("-",H74)-3,10),MID(H96,FIND("-",H74)-3,8))

However this formula is only a part of a larger and i did not want to make it even more unreadable than it already is.

 

[Archijs]

Any ideas?