Extract Everything Left of 3rd Underscore from Right

Question

Hello all,I am working on building a formula that will extract everything left of the 3rd underscore from the right.&nbsp;Sample date: 139_EDWARDS_DR_NW_VIENNA_VA_20176Desired result: 139_EDWARDS_DR_NWI have tried variations of Part, Left, NotLeft, Right, NotRight, Find and just can't seem to figure it out.&nbsp; Anyone have a solution?

markshnier__you · Answer

This tests OK for me.NotRight(NotRight(NotRight([My Underscored String],"_"),"_"),"_")

Forum Discussion

Extract Everything Left of 3rd Underscore from Right