Isolating RIGHT value

goosteroo

New Member
Joined
Oct 28, 2005
Messages
42
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
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
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
Joined
Feb 17, 2002
Messages
13,686
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
Joined
Jul 21, 2002
Messages
73,092
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,016
Messages
5,569,628
Members
412,284
Latest member
Daibear
Top