Excel: Extract A String Between Two Characters

I'm stuck. I need a formula to extract data from between two characters. For Example, In A1 I have this: COMP_PROG_v1_ABCD_01 I want to extract the value between the 3rd and 4th "_"'s. The number of "_"'s will be consistent but not the # of characters between them. My brain is tired of thinking. Thanks.

This question generated 40 answers. To proceed to the answers, click here.

This thread is current as of January 27, 2010.

For more resources for Microsoft Excel