im trying to use =proper(a1) but i need to then be able to move the text that has then been placed in the box, when ever i try to move it it only moves the =proper(a1) im sure there is a better way to do this but i cant seem to find it. weather that be in vba or some other formula