Replacing a sentence ending to a character

When I want to replace a content ending to e.g.">"; I replace "*>" with nothing

but if there is two > in the cell, it will deletes the content up to the second >; how I can delete the content to the first > only?

For example in the content

word1 word2 > word3 word 4 > word5 > word 6

how I can replace (or delete) only "word1 word2" ?

Is this what you want?

=SUBSTITUTE(A1,LEFT(A1,FIND(">",A1)+1),"")

Originally Posted by rocky1

Is this what you want?

=SUBSTITUTE(A1,LEFT(A1,FIND(">",A1)+1),"")

It worked perfect, but can you tell me about other cases

1. Replace "word3 word4"
2. Replaced "word3 word4 > word5"
3. Replace "word6"

Thanks

I'm not sure I fully understand.

This is what we started with >> word1 word2 > word3 word 4 > word5 > word 6

You first asked remove word1 word2, but now there is another requirement...

What do you want to end up with?

Originally Posted by rocky1

I'm not sure I fully understand.

This is what we started with >> word1 word2 > word3 word 4 > word5 > word 6

You first asked remove word1 word2, but now there is another requirement...

What do you want to end up with?

You answer my first question fully; but as your solution is flexible, I am asking for new questions. I wanted to open a new thread for new questions, but I thought it is better to continue it here.

Okay so what is the new question?

In the content word1 word2 > word3 word 4 > word5 > word 6

1. Replace "word3 word4" (words at the middle)
2. Replaced "word3 word4 > word5" (words at the middle with the character)
3. Replace "word6" (words at the end)

Number 3 I can probably figure out, but #1 and #2 will take a little longer if I can even figure it out.