If Perth WRX was in cell A1, you'd go =right(A1,3)
A1 being the cell reference, and 3 being the amount of characters from the right you want in your destination cell.
Alternatively for Perth, it'd be =left(A1,5)

Or you could do the above