Mid Function Help

[scott4lud]

Could someone assist me with getting the ORANGE out of the following if the following value was in A1. Keep in mind this formula would have to work for all the product codes. The color would always be between the underscores though.

PKT SQ_ORANGE_T

 

[Rasm]

try this


Dim Avar
Avar=split(the cell location,"_")



Avar(1) will be the product code

 

[Giordano Bruno]

For a formula solution you could use
=MID(A1,(FIND("_",A1)+1),FIND("_",A1, (FIND("_",A1)+1))-(FIND("_",A1)+1))

 

[AlphaFrog]

Or this....
=TRIM(MID(SUBSTITUTE(A1,"_",REPT(" ",99)),99,99))

 

[Giordano Bruno]

Beautiful!

No wonder you are called AlphaFrog.