Try this in an empty column - it assumes the "raw" postcode is in A1

=IF(MID(A1,LEN(A1)-3,1)=" ",A1,LEFT(A1,LEN(A1)-3)&" "&RIGHT(A1,3))

and if by chance you want them all upper case use:

=UPPER(IF(MID(A1,LEN(A1)-3,1)=" ",A1,LEFT(A1,LEN(A1)-3)&" "&RIGHT(A1,3)))

Sandy

"Ianwal" wrote in message
...
Help please as daily we produce a list of addresses and post codes and
some
clients put a space between the numbers and some do not. We need a space
always