gbritton1 (5/1/2014)
If the numeric portion is variable length, add a call to InStr:
=Left("1234-abc",InStr("1234-abc","-")-1)
That's your answer, just replace the hard-coded text with your Field name.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question