ZIP CODE SORT

[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?

 

[Frank Kabel]

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

 

[RagDyeR]

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

 

[Frank Kabel]

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