Zip Code problems

vickiecroft

New Member
Joined
Nov 21, 2005
Messages
34
I have a spreadsheet with zip codes entered. Some are 5 digits and some are 9 digits. I want this formatted with 5 digits then I will need to filter only unique records.

I used the = left(cell, 5) formula which worked great on formatting the Zip Code to 5 digits but I can't filter unique records, (I think the zip code is formatted as text.

Any suggestions,

Vickie
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
Welcome to MrExcel - you could create an entire Text listing by

=TEXT(LEFT(A1,5),"00000")

Copy -->Paste special | Values

Copy down B as far as data in A, then filter on column B.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,424
Messages
5,572,030
Members
412,434
Latest member
Tawanda K Chakuma
Top