How many different values are there in the {Home} text field? Do you have a complete list of all possible values? If you have only a limited number of possible values, you can use the pattern in the SWITCH() function that Alexey pointed out. However, if you have many values, the values might change, or new values might be added, you may need a different approach so you don't have to constantly update the formula whenever a new name is entered.
I can't see the logic used to determine the {Bot Name}. It seems like most of the time you strip out the word "Team" from the beginning and ensure that "FC" is at the end. This logic could be implemented with a formula, but it would be formula with multiple nested functions, not a simple SWITCH() or IF(). However, then you have "Team DEF" which doesn't fit that pattern, so you may need something more complex.
Does a single value in the {Home} text field occur in multiple rows? If this is commonplace, consider using a linked table with one field for the {Home} field value and another field for the {Bot Name} and use a lookup field for the {Bot Name}. Do the three parts of the {Home} field value each have meaning? If so, consider using three different fields for the individual parts, and then consolidate the info in a formula field.
