| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display contents of cell in another cell as part of text string? | New Users to Excel | |||
| Matching Text with With Certain Criteria | Excel Worksheet Functions | |||
| How do I test a cell for part of text | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| how to count the nr of occurrences of a text string in a cell rang | Excel Worksheet Functions | |||
Linear Mode
