Visual Basic Help!

[tucker]

Does anyone no how to write a macro to reformat postcodes to be the
same arrangement. The final postcodes must be no longer than 8
characters. There must always be a space in between the outward and
inward code, for example
• B4_7ET
• OX8_5KQ
• OX28_5KQ

The problem is, the list of postcodes which have been collected have
mixed formats, e.g,


• B_4_7ET
• B4_ _7ET

 

[Paul Herber]

Does anyone no how to write a macro to reformat postcodes to be the
same arrangement. The final postcodes must be no longer than 8
characters. There must always be a space in between the outward and
inward code, for example
• B4_7ET
• OX8_5KQ
• OX28_5KQ

The problem is, the list of postcodes which have been collected have
mixed formats, e.g,


• B_4_7ET
• B4_ _7ET

Answered in the VBA group