Show me only the characters after a specific character

[Hayley]

I'm not sure if this is even possible, but I have a bunch of URLs in column A that all start with https://www.mycompany.com/businessline/salespeople and then end differently based on what page they land on. For example:
https://www.mycompany.com/businessline/salespeople/jsmith
https://www.mycompany.com/businessline/salespeople/rdonatello
https://www.mycompany.com/businessline/salespeople/office/chicago
https://www.mycompany.com/businessline/salespeople/office/amsterdam
https://www.mycompany.com/businessline/salespeople/product/widget
https://www.mycompany.com/businessline/salespeople/product/cog

In column B I want to isolate only the stuff after "salespeople". So I want column B to show me:

jsmith
rdonatello
office/chicago
office/amsterdam
product/widget
product/cog

Is there a formula that will do that for me? I can't do =RIGHT because the number of characters I need varies. Is there anything that will do it for me?

 

[vletm]

Hayley
Why You cannot use '=RIGHT'?
for cell [B2] =RIGHT(A2,LEN(A2)-(FIND("salespeople",A2,1)+11))

 

[Hayley]

Hayley
Why You cannot use '=RIGHT'?
for cell [B2] =RIGHT(A2,LEN(A2)-(FIND("salespeople",A2,1)+11))

I guess I can! That worked! So this is saying from the right, take the length of the URL in A2 minus...? what's the "find" and "+11"?

 

[vletm]

Hayley
FIND
Finds one text string (find_text) within another text string (within_text), and returns the number of the starting position of find_text, from the first character of within_text.
+11
Lenght of "salespeople"

 

[bosco_yip]

Another option,

If Column A data all started with https://www.mycompany.com/businessline/salespeople,
you can try this shorter formula :

=MID(A2,52,99)

Regards
Bosco

 

[Khalid NGO]

Hi,

One more way with Find & Replace option:

1) Select your range
2) Press Ctrl+H (Find & Replace)
3) Find what: *salespeople/
4) Leave blank Replace with field
5) Replace all

Regards,