ZIP CODE SORT

  • Thread starter Thread starter CHUCK
  • Start date Start date
C

CHUCK

I want to sort data by zip code but the zip code and
address info is all in one column. I want to move the zip
code (last five digits in address col) to another column
for this sort. How can that be done?
 
Hi
is the ZIP Code is always the last 5 characters of a cell enter the
following formula in column B
=RIGHT(A1,5)
and copy this down
Now sort with this helper column
 
Seems I'm answering reposts of questions you've already replied to Frank.

Don't realize it ''til *after the fact*, when I read down the group.

Using O.E., I guess I'll try "ReplyAll", instead of "ReplyGroup", to include
OPs own address.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

Hi
is the ZIP Code is always the last 5 characters of a cell enter the
following formula in column B
=RIGHT(A1,5)
and copy this down
Now sort with this helper column
 
Hi
no problem with that :-)
I think the OP is encountering the problem not to be able to read our
responses. Seems to be a problem with the CDO interface. -> So he won't
be able to read either of our messages
 
Back
Top