Extract number out of long text

[tantcu]

Hello,

Does anyone know how to extract number out of this text. For example,

Central Pet - Auburn-Seattle - 4169
C & S WHOLESALE GROCERS - 7304
ALBERTSON'S - 28982
MERCHANTS DISTRIBUTORS, INC. - 3860
OVERWAITE FOOD GROUP ( SAVON FOODS) - 13866
VALLEY FEED & SEED (K) - 3337


All I want is the number behind the dash.


Thanks

[judgeh59]

give this a shot -- assumes data is in A1

=RIGHT(A1,LEN(A1)-FIND("-",A1) -1 )

[tantcu]

I tried the formula and the first one return AUBURN-SEATTLE - 4169. Is there a way to return 4169 only?

[judgeh59]

I didn't notice you had multiple "-"....

[judgeh59]

not mine but it seems to work

=RIGHT(A1,LEN(A1)-SEARCH("@",SUBSTITUTE(A1," ","@",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))

[XOR LX]

Hi,

Will there always be only one occurrence of a number in a given string?

Regards