Hi there,

I am looking to parse out text from a data string, example below:

AX_TEST_EXAMPLE_XYZ [13141-14141-14]

Using LEFT I can get the first two letters and using RIGHT I can get the final string between the [], I used MID to get the TEST text by using the FIND function. Now I am stuck, as I need the text between each "_".

Is there a way to define the first, second and third "_" in the MID formula?

Thanks