Formatting

Hi Nikaya

Thanks for getting in touch.

UK postcodes are irregular in length which makes them awkward to work with in Excel. You can use LEFT and RIGHT functions to extract portions of the data. If the postcode is located in cell A1:

=LEFT(A1,LEN(A1)-3)

will extract the first part

=RIGHT(A1,3)

will extract the second part.

They're a bit confusing if you haven't come across them before so just let us know if you need more info.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector