How do I write a query to format postcodes so that they are XXnn nXX. Currently some are xxnnnxx etc. ? I also need to make sure there is a space after the last number before a letter for example W1N 6BL
Also can I put a bit of code in so that when new ones are inputted the correct formatting is applied - maybe an after update ?