# Isolating RIGHT value

#### goosteroo

##### New Member
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.

Kevin

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### NBVC

##### Well-known Member
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

##### MrExcel MVP
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

##### MrExcel MVP
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.

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,168,127
Messages
5,857,528
Members
431,883
Latest member
Hien

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back