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
 

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.
 

Forum statistics

Threads
1,077,834
Messages
5,336,661
Members
399,095
Latest member
globz

Some videos you may like

This Week's Hot Topics

Top