A. Yes, there is. Here are the steps:
If the ZIP codes are in column D, create a new column just to the right, in column E.
Enter this formula in E1: =Left(D3, 5) and then copy it into all the rest of the cells in column E.
vHighlight the entire column D and copy it (Ctrl+C) into the Clipboard .
n Go to the Edit menu and click on Paste Special and select the Values radio button and click on OK . Delete column D; by doing that, column E, with the now shortened codes, becomes column D.