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 wrote in message
...
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 wrote in message
...
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