Remove last two characters from string

[DougStroud]

In this range I have a series of string values that I want to remove the last two characters if they are the two Greater Than Signs ">>"

My formula only returns the length count.
Accessories>>Youth>>
Accessories>>Accessories>>
Accessories>>Accessories>>Wristbands

=IF(RIGHT(D4,2)=">>",LEN(D4)-2,D4)
=IF(RIGHT(D5,2)=">>",LEN(D5)-2,D5)
=IF(RIGHT(D6,2)=">>",LEN(D6)-2,D6)

I get the following results, for D4 and D5 I want the text string.
18
24
Accessories>>Accessories>>Wristbands

I recoginize I need to get out of the LEN function to return the text, but don't see how to get there.

thanks once again,

 

[Aladin Akyurek]

Hard to follow... Guessing that...

=IF(RIGHT(D4,2)=">>",LEFT(D4,LEN(D4)-2),D4)

 

[klb]

=IF(RIGHT(D4,2)=">>",LEFT(D4,(LEN(D4)-2)),D4)

 

[Lewiy]

=IF(RIGHT(D4,2)=">>",LEFT(D4,LEN(D4)-2),D4)

 

[DougStroud]

That got it, thanks gentlemen.