Isolating RIGHT value

[goosteroo]

Hi all. I think this is pretty easy, but I can't get the formula to work. Bascially, I want to isolate the value on the furthest right. It immediately follows a "-" symbol, but is variable in length.

i.e.

TO#0005117-Delta Airlines-Dec05-Travel-728x90

I just want "728x90" displayed in another column.


Many thanks in advance.

Kevin

 

[NBVC]

Hoping there are always 4 dashes, then you can try:

=RIGHT(I9,LEN(I9)-SEARCH("@",SUBSTITUTE(I9,"-","@",4))), where I9 contains the original string

 

[Von Pookie]

Another way (should work if the number of dashes will be variable):

=MID(A1,FIND("~",SUBSTITUTE(A1,"-","~",LEN(A1)-LEN(SUBSTITUTE(A1,"-",""))))+1,LEN(A1))

 

[Andrew Poulsom]

Maybe try:

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

If your string can contain @ change it to some other unlikely character.