I am working with model numbers similar to this: ESLC148-12T
What formula can I use to extract just the numbers (in this case,"12") from the right of the dash?
I am using =REPLACE(W4,1,FIND("-",W4),"") to show me everything after the dash but I can't find how to go from there.
What formula can I use to extract just the numbers (in this case,"12") from the right of the dash?
I am using =REPLACE(W4,1,FIND("-",W4),"") to show me everything after the dash but I can't find how to go from there.