Tried all the standard ways, sorting, find and replace, couldn't find anything.
2007-01-03 08:45:08 · 4 answers · asked by phyzzzy 1 in Computers & Internet ➔ Software
It's easy, a formula to truncate the numbers to 5 in the next column.
If your data is in column A1, put this in column B1.
=LEFT(A1, 5)
It will take the first 5 letters of data from column A.
2007-01-03 08:48:45 · answer #1 · answered by Anonymous · 2⤊ 0⤋
9 Digit Zip Code Format
2016-11-07 11:28:29 · answer #2 · answered by zanchez 4 · 0⤊ 0⤋
Insert a blank column next to the column with the 9 digit zip codes, then insert the formula:
=Left(D1, 5)
This formula assumes the 9 digit zip is in column D. Change as appropriate. Then double click the box in the bottom right corner of this cell and it will copy the formula all the way to the bottom.
2007-01-03 08:52:57 · answer #3 · answered by WowLights 2 · 0⤊ 0⤋
select all of the cells then select format cells go to > Number- Category > Special > Type will be Zip code instead of Zip code + 4
2007-01-03 08:53:13 · answer #4 · answered by lv_consultant 7 · 2⤊ 0⤋