The search Text provided to function 'FIND' could not be found in the given text.

Hi josephtsmith ,

Try to modify the formula like this:

Work Type = 
VAR a =
    RIGHT (
        'Work Order'[Work_Type_Service_Coverage__c],
        LEN ( 'Work Order'[Work_Type_Service_Coverage__c] )
            - FIND ( "-", 'Work Order'[Work_Type_Service_Coverage__c] )
    )
RETURN
    LEFT ( a, FIND ( " -", a ) )

Attached a sample file in the below, hopes it could help.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.