UK Postcode as a continous string 1

[earthandfire]

CorrectPostCode = Left(WrongPostCode, Len(WrongPostCode) - 3) & " " & Right(WrongPostCode, 3).

Regardless of how many characters in the postcode, it consists of two parts an Outcode and an Incode, the second part is the Incode which is always three characters Number, Letter, Letter.

Hope this helps

 

[Nicos67]

Hello all,

Need help to change UK postcodes which are set out as follow:

WA28WA

CH451NT

That is 6 or 7 in a string I need them to look like this:

WA2 8WA
CH45 1NT

That is with a space after the 3rd figure if 6 figures in string , or after 4th figure if 7 figures in string

Please advise