With your data in A1, this formula will work given that "(BTL-3) 1177 " will
always precede the number that you want to return.
=RIGHT(A1,(LEN(A1)-FIND("(BTL-3) ",A1)-12))
Hope this helps,
Paul
"wolfpack95" wrote
in message ...
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.
--
wolfpack95
------------------------------------------------------------------------
wolfpack95's Profile:
http://www.excelforum.com/member.php...info&userid=93
View this thread: http://www.excelforum.com/showthread...hreadid=497953