I need to extract the route number, which can be between 1 to 3 digits, see example below:
Route 1-1 South
Route 26-7 Ludlam
Route 29-2 West
Route A 101-1 North
As you can see the Route value and (-) dash character are constant.
Is there a formula in excel and/or PowerBi I can use...