probably really simple / stupid excel question

StoneTZ

Under the Man's Thumb...waaaaaa!
Joined
Oct 12, 2009
Messages
737
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.
 
Code:
=CONCATENATE(A1,".jpg")

A1= cell with your number
 
Last edited:
Code:
=CONCATENATE(A1,".jpg")

A1= cell with your number

There is a reason you're [H]ardness supreme.

If you wanted to put it in front would you just do something like:
Code:
=CONCATENATE(".jpg",A1)

Thanks a ton, this was killing me, to vague to find a good answer on google and doing it by hand would have taken forever.
 
Back
Top