I'm trying to create a formula field that returns a number. The source of the field is a text value such as the following examples.
The goal is to store the values in bold above in the formula number field. I believe this is possible with a couple text functions (Begins, Find, Left and Right) wrapped in a Value function to return the number represented by the text highlighted above.
Can you solve this?