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 I could do a Text to Columns with a space delimiter but was hoping to find something easier. Thanks in advance for any help.
Bookmarks