Excel separate postcode formula
Here we go (H2): "Someplace XX8 8XX" =RIGHT(H2,(LEN(H2)-FIND(" ",H2))) kinda works, except if Someplace has additional spaces in it. Looks like you could do a find from the right to left and make it more fool proof but that would involve a bit of VBA.