Hello all,
Would anyone be able to help? Using example data below and the length will be different for each row.
in cell A1 data:
John Doe XXX X-1 Do Not Know XXX-Xvnbnn abbn-mnmmm-22288
in B1>> I would like the formula to look for 2 hyphens from right and return that set of data. Below is the formula I use, it gives some, but not working well.
=RIGHT(B2, SEARCH("-", B2)-5)
The result in B1 would be: abbn-mnmmm-22288
Thank you kindly for helping!
Bookmarks