Is there any way I can take the content of a cell and put a space in at a given point in each cell?
I've got a list of postcodes that I need to put the gap in the relative place (ie. before the final three characters). I was thinking that I could split the cells then re-join them with a space in the middle. But I don't know how to do this...