You can use the LEFT function to return the left-most characters
of a string. E.g.,

=LEFT(A1,3)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Keith Radley" wrote in message
...
I'm looking for a fast way to strip off the first three
characters of a zip code and write it to an adjoining column to
get a SCF (US Post Office Sectional Center Facility) code;
which would then let my sort by SCF.