removing part of text string to another cell
 

hey. i have an enormous list of addresses with the whole address in one
cell for each address. i need to extract the postcode (zip) to another
cell so that i can sort the data by postcode. each line of the address
is separated by a space. can anyone help me? Please!


--
jamie_k
------------------------------------------------------------------------
jamie_k's Profile: http://www.excelforum.com/member.php...o&userid=36687
View this thread: http://www.excelforum.com/showthread...hreadid=564192

removing part of text string to another cell
 

A sample (or two) of the address format would help.

"jamie_k" wrote:


hey. i have an enormous list of addresses with the whole address in one
cell for each address. i need to extract the postcode (zip) to another
cell so that i can sort the data by postcode. each line of the address
is separated by a space. can anyone help me? Please!


--
jamie_k
------------------------------------------------------------------------
jamie_k's Profile: http://www.excelforum.com/member.php...o&userid=36687
View this thread: http://www.excelforum.com/showthread...hreadid=564192

removing part of text string to another cell
 

On Mon, 24 Jul 2006 04:18:58 -0400, jamie_k
wrote:


hey. i have an enormous list of addresses with the whole address in one
cell for each address. i need to extract the postcode (zip) to another
cell so that i can sort the data by postcode. each line of the address
is separated by a space. can anyone help me? Please!

It's probably simple to do with Regular Expressions or possibly with built-in
functions. But samples of your addresses (with the possible variations) is
required.


--ron