I have a text field with hundreds of words. Imbedded is a unique string (Inc#) followed by a number, varying in length (i.e. 17-12, 17-123, 17-1234, 17-122345, 17-123456) but never more that six numbers. I need to put only the [Inc#] and the [following number] in a calculation field.
I have tried everything; have come close but no cigar. Please HELP!