I am not strong in Excel. I have never used script or record. I have a site map with typed numbers in the cells but I want them to have colons because they are MAC address's. I have tried alot of these ideas but it cuts out numbers/letters. If i make a whole copy of just one large set I have got it to work ish. I copy it and erase my old cell info to paste in the new stuff but both disappear when I do it? Any ideas for a learner of this?