Ok, I've been working on this / googling for quite a bit and I am about to give up. I'm hoping this is something an excel wizard can answer in 10 seconds. Thanks in advance. I've got an excel sheet with a column that has numbers like: 10001 10002 10003 10005 10008 etc etc etc I want to change this to: 10001.jpg 10002.jpg 10003.jpg 10005.jpg 10008.jpg etc etc etc I've tried using formulas / macros and I'm getting frustrated. This shouldn't be that hard should it? Anyone that could give me a hand real quick? Thanks! Edit: made sure relative was on when I made my macro but it still screwed up.