Single formula for required results

Pls advice how to create formula for below…

 

 

Actual Values Required results by formula for (the text after the  specified symbol “-“)
ABCD-875W 875W
ABCD-865W 865W
ABEECD-874W 874W
ABC74D-3751W 3751W
ABC54D-885X 885X
ABERCD-975W 975W

By: Shaju

Leave a Reply

Your email address will not be published. Required fields are marked *