Function that enables me to extract text in the middle of a cell

try:

Please Login or Register  to view this content.

FIND("Company:",B2) is a position in B2 letter C (from "Company:")
so now you know how many charcacters are before Company.
Before there is space so you need this position -1
but ... you dropped first 15 characters from the left so -15
-1-15 = -16
and that: FIND("Company:",B2)-16 is the length of substring you want to extract.

Of course, instead of "hardcoding" 15, you could also use another FIND to determine the start of substring.

=MID(B2,FIND("Name",B2,1),FIND("Company:",B2)-1-FIND("Name",B2,1)+1)
Take a look at this.

Hi Willem,
Taking seriously what you have written in the signature:
Your formula will return too long substring (extra space at the end):
>Name: Ben Fred <
Adding one at the end makes anyway no sense from mathematical point of view, as you are subtracting it earlier, so after some rearrangement it would be:
=MID(B2,FIND("Name",B2,1),FIND("Company:",B2)-FIND("Name",B2,1)-1+1)

Anyway, right version is:
=MID(B2,FIND("Name",B2,1),FIND("Company:",B2)-1-FIND("Name",B2,1))

and this is exactly what I ment:

Of course, instead of "hardcoding" 15, you could also use another FIND to determine the start of substring.