zip code

  • Thread starter Thread starter chuck
  • Start date Start date
Probably the easiest way would be to use "TextToColumns", but since you
didn't post the exact format of your data, its difficult to suggest how you
could use this function.

However, since you state that the *last* five digits are the zip, enter this
in the next column and drag down to copy:
Assume data in column A:

=RIGHT(A1,5)
--

HTH,

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

frank -- your message was unavailable....do you have any
answer to the zip code question
 
There is a problem with the Microsoft newsgroup interface.
Until it is fixed, you can search for replies to your
messages in the Google archive:

http://groups.google.com/advanced_group_search?
as_ugroup=*excel*

The answer Frank gave was:
'===========================
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
'===========================
 
Back
Top