probably really simple / stupid excel question

Discussion in 'General Software' started by StoneTZ, Jan 14, 2011.

  1. StoneTZ

    StoneTZ Under the Man's Thumb...waaaaaa!

    Messages:
    737
    Joined:
    Oct 12, 2009
    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.
     
  2. Met-AL

    Met-AL [H]ardness Supreme

    Messages:
    7,874
    Joined:
    Apr 9, 2002
    Code:
    =CONCATENATE(A1,".jpg")
    A1= cell with your number
     
    Last edited: Jan 14, 2011
  3. StoneTZ

    StoneTZ Under the Man's Thumb...waaaaaa!

    Messages:
    737
    Joined:
    Oct 12, 2009
    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.