I am attempting to extract two digits from the right side of a string.
Input string can end with digits or text. For example, "Hitch Rack - 4-Bike" and "Mountain-100 Silver, 38". My end goal is to pull the last two digits if they exist into another cell. If the initial string doesn't end with the digits, I want to output a " ".
Currently my brain is telling me this, where [@Product] is the input cell string value: =IF(ISNUMBER(RIGHT([@Product],2)),RIGHT([@Product],2)," ")
Using the two input examples above I should get " " (space) and 38 as the outputs respectively.
Thanks for taking a look!
Aucun commentaire:
Enregistrer un commentaire