Extracting last 5 characters from a cell

I am trying to extract the last 5 characters from a cell and enter them in a
seperate cell. I have several thousand addresses that I have in excel and I
want to pull the zip codes out and have them in a seperate cell so I can sort
them by zip code.
Basically cell A is a complete address and I want cell B to contain the zip
codes

Hi colleen

See the Excel help for the right function

=RIGHT(A1,5)



--
Regards Ron de Bruin
http://www.rondebruin.nl


"colleen Curley" <colleen [email protected]> wrote in message
news:[email protected]...
>I am trying to extract the last 5 characters from a cell and enter them in a
> seperate cell. I have several thousand addresses that I have in excel and I
> want to pull the zip codes out and have them in a seperate cell so I can sort
> them by zip code.
> Basically cell A is a complete address and I want cell B to contain the zip
> codes

You are a life saver. Thanks

Colleen

"Ron de Bruin" wrote:

> Hi colleen
>
> See the Excel help for the right function
>
> =RIGHT(A1,5)
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "colleen Curley" <colleen [email protected]> wrote in message
> news:[email protected]...
> >I am trying to extract the last 5 characters from a cell and enter them in a
> > seperate cell. I have several thousand addresses that I have in excel and I
> > want to pull the zip codes out and have them in a seperate cell so I can sort
> > them by zip code.
> > Basically cell A is a complete address and I want cell B to contain the zip
> > codes
>
>
>