Extracting Text from a text string

Apologies if this has been asked before, but as a newbie to all things Power BI this is proving a bit of a pain.

The data I'm working with needs a certain bit of tidying before it's used.  One of the the things that is proving difficult is extracting a certain text string from another - it's easy enough to do in Excel/Access but I'm strugging with it here.

What I have is this....

and in Excel =IFERROR(LEFT(RIGHT(A2,LEN(A2)- FIND("SBCR",A2,1)+1), FIND(" ",RIGHT(A2,LEN(A2)- FIND("SBCR",A2,1)+1))),RIGHT(A2,LEN(A2)- FIND("SBCR",A2,1)+1)) does the trick

I've tried doing it as the data is imported but it gets messey pretty quickly.

I've also tried adding a measure using ....

IsCR = if(FIND("SBCR",[Activity],1,-1)>0, RIGHT([Activity],LEN([Activity])-FIND("SBCR",[Activity],1,-1)), "")

This gets me the first part but I'm struggling to knock off the text string at the end.

Unfortunately I can't ask that the data is aperated before I get it.. 

Regards,

Tony