| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving post code data to a different column
Hi,
I have an excel sheet containing customer addresses. This sheet contains following columns - 1. Customer Name 2. Address 1 3. Address 2 4. Address 3 5. Address 4 6. Address 5 Ideally I want all the postcode in 'Address 5' column. Unfortunately since the address is not in any standard format, the post code is every where. In some record, it is in second column. In some it is in 3rd column and so on. Is there any way I can move the post code into the 6th column (Address 5)? The post code is all in caps. Harish Mohanbabu -- MBS Axapta - MVP http://www.harishm.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Does anyone know how I can seperate a post code in my data sheet? | Excel Discussion (Misc queries) | |||
| Simple column moving code needed | Excel Programming | |||
| Freezing the data in a column and moving the calculations to the next column | Excel Programming | |||
| moving data within a column | Excel Worksheet Functions | |||
![Harish Mohanbabu[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
