
Hello,
How may i go about splitting this string "Order ID - 80002213411". I want to pull the number out of the string.
Thanks
Like this:
Value(Last(Split("Order ID - 80002213411"," - ")).Result)
Or if you want to find the 1st number at any position in a text string use regular expressions.
Match("Order ID - 80002213411","[0-9]+").FullMatch
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."