Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-19-2013, 06:45 AM
Chayes Chayes is offline Identifying Postcodes. Windows XP Identifying Postcodes. Office 2003
Advanced Beginner
Identifying Postcodes.
 
Join Date: May 2012
Posts: 79
Chayes is on a distinguished road
Default

Hi Tony

Ok that's great. Thanks again for your help.



Best wsihes
Reply With Quote
  #2  
Old 09-20-2013, 04:37 PM
Chayes Chayes is offline Identifying Postcodes. Windows XP Identifying Postcodes. Office 2003
Advanced Beginner
Identifying Postcodes.
 
Join Date: May 2012
Posts: 79
Chayes is on a distinguished road
Default

Hi Tony

I just found a small anomally. My fault.

I sometimes have codes on the same page as the addresses. They always involve the letters 'BX'.

For example

12571BX175

I'm finding the coding is picking this up in error , and identifying as a postcode.

Could the code be made to ignore anything with the letters BX in? Hope you don't mind.
Reply With Quote
  #3  
Old 09-21-2013, 02:57 AM
OTPM OTPM is offline Identifying Postcodes. Windows 7 32bit Identifying Postcodes. Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
As a quick fix because I am not at home follow these steps:
Search for ^pBX
Replace with BX
This will resolve your issue.
Good luck.
Tony
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Identifying Postcodes. Identifying Irregular Characters d4okeefe Word VBA 2 05-09-2013 03:14 PM
Identifying Postcodes. Identifying and counting words monique Word 1 08-30-2012 05:33 AM
Identifying the Dynamic Connector cyberbhai Misc 0 12-14-2005 03:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft