Need formula to compare A&B column values after every hyphen sign

[breadwinner]

Dear experts

I have range of data in A:B with delimited of hypen - i want compare A & B column get result in D through value of each before delimiter of hypen


i need formula to compare get result as like value after hyphen
:Co_Code-Account-LOB-Sub Account-ICO-CURRENCY

Like A= 0023-535002-N79-B1451-0000-PLN And B=0023-535002-N79-P2110-0000-PLN
Result Sub Account becoz difference is between B1451&P2110

find the attachment

Thanks in advance

[zbor]

Here, try this UDF:

[Mandeep Baluja]

Please Login or Register  to view this content.

[breadwinner]

Thanks alot sir Both Code Perfect Piece of work!!Solved