Read from Right

Q: Is there a function to read values starting from the right of a cell and pulling characters until I reach a space?

Two examples:
SGA3220R_IAOAKTREE (BTL-3) 1177 64089 - would return "64089"
SGA3321R_IAREDROAD (BTL-3) 1177 975 - would return "975"

I know we could do a Text to Columns with a space delimiter but if there are multiple spaces it would distort the data.

 

 

Try using this formula

=RIGHT(A2,(LEN(A2)-FIND(" ",A2)))