deleting the last 5 digits per cell

[Shaolin]

In column E row 2 to about row 700, I would like to delete the last 5 digits in each of those rows.

Imagine an address with the zip code at the end. How can I delete the zip code (last 5 digits) in excel?

[lifeson]

=LEFT(A1,LEN(A1)-5)

assumes the text string is in A1 and there are no spaces

[Shaolin]

Thanks for your help.