Can I remove the first part of a string of text and keep the second part?

Hi Everyone,

Is there any way to remove the first part of a string of text in a cell and save the second part?

The first part of the text string is a team code that has a variable number of numbers, capital letters and sometimes spaces. The second part of the text string is a variable number of words in a team name that all start with a capital letter and have lower case letters. Every line has a different team code and team name.

The original spreadsheet also has a column with just team code. Is there a way of using this column to ‘subtract’ the team code from the text string to just leave the team name?

Thanks in advance for your help.

Example:

Thanks, Etaf and Allkey!

Both solutions worked. Y'all have saved a bunch of time.

Cheers!
Whoop92

ps. Sorry about the image, I'll do better next time.