I have the following cell of text bRef:0261322cRef:0261322TestDate

I want to extract the numbers between bRef: and cRef: ie.0261322


This string is of characters is not always the same length. I am using the formula below but it won't work as it's numbers being returned. Any ideas on how to do this?

=MID(N4,FIND("Bref:",N4)+4,(FIND("Cref:",N4)-(FIND("Bref:",N4)+4)))

=mid(n4,find(":",n4)+1,find(":",n4,find(":",n4)+1)-5-find(":",n4))

I cannot use just the colon as I have many colons in the string. I need to search for the specific text.

The easy way:
Ctrl+H
Replace what :"bRef:" (no quotes)
With : (leave empty)
Replace All
Ctrl+H
Replace what :"cRef:*" (no quotes)
With : (leave empty)
Replace All

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Then maybe:

=MID(N4,FIND(A1,N4)+LEN(A1)+1,FIND(A2,N4)-LEN(A2)-2)

where A1 = bRef and A2 = cRef.