Question EXCEL and WPS - MID function ?

[rahul.gaming29071990]

Hi Everyone,

I need to pull specific middle text from the specific cell but I am not sure as to how I can using MID function:

Below are the 5 cells from which I want to pull text that contains 6 alphanumeric (12G3WR) with the condition of each cell having different length. Can anyone share the formulae with explanation. I tried using MID + FIND and MID + SEARCH but not getting the result.

A_B_CCC_12G3WR_A2_6D

A_B_C_12G3WR_A2_6D

A_BD_CCC_12G3WR_A_6D

A_BCC_CCC_12G3WR_A2_6D

A_BAC_CC_12G3WR_A2_6D

 

[ex_bubblehead]

With strings of differing lengths you are going to have to find something common to all elements in each string and use that. In your examples above the desired string always follows the 3rd "_". I'll leave the coding up to you.