Hi all,

I have a worksheet that has a column with loads of postcodes (5000 altogther). I need to split these postcodes into their two parts - Now this wouldn't be a problem if they were all the same length I.E GU73BT can easily be split into GU7 3BT using Data->Text to columns.

Some of the postcodes I am dealing with are in this format; N57QB, whilst others are GU145TR. The thing with UK postcodes is that the second part of the split must contain 3 characters I.E the 7QB and 5TR.

I hope this makes sense and that there is some solution, what I ideally need to do is use the Text to columns function but inversley.....From the right to left!

I would do this manually but as I said there are over 5000 rows!

Thanks in advance

Rich