Excel formula

[Formulawiz]

Have the following formula in Excel
=SUBSTITUTE(D2,"at","")
When I apply it to
Seattle at
Cincinnati at
the at disappears which I want but I get the following names
Setle
Cincinni
How do you remove the at after each team name
It works fine for all other teams.

[LT Profits]

Try putting a space before the "at".

So:

=SUBSTITUTE(D2," at","")

[runnershane14]

or you could do

=LEFT(D2,LEN(D2)-3)

[Formulawiz]

Works Fine
Thanks