Excel help please

Discussion in 'Bulletin Board ARCHIVE' started by Andy Mac, Feb 25, 2009.

  1. Andy Mac

    Andy Mac Well-Known Member

    Joined:
    Apr 26, 2006
    Messages:
    12,486
    Likes Received:
    12,767
    Trophy Points:
    113
    Gender:
    Male
    Occupation:
    IT
    Location:
    Sweet Home Bingley.
    Style:
    Barnsley Dark
    I have a column with about 300 rows of random 5 digit numbers, for eg 43581</p>

    Each of these numbers I have to prefix with WKS, for eg the above number needs to become WKS43581</p>

    Is there an easy way to do this please ?</p>

    Regards</p>

    Excel Numpty</p>
     
    Andy Mac, Feb 25, 2009
    #1
  2. Gue

    Guest Guest

    I'd make another column, type the prefix in the top row. In another column type =Cell1&Cell2, then drag down all 300 rows.

    Or look at Concatenate, however you spell it.
     
    Guest, Feb 25, 2009
    #2
  3. BrunNer

    BrunNer Well-Known Member

    Joined:
    Sep 25, 2007
    Messages:
    5,672
    Likes Received:
    6,204
    Trophy Points:
    113
    Home Page:
    Style:
    Barnsley (full width)
    Enter
    =CONCATENATE("WKS",A2)
    and drag the formula down.

    where A2 is the cell reference of the number you want to use as a suffix.
     
    BrunNer, Feb 25, 2009
    #3
  4. Andy Mac

    Andy Mac Well-Known Member

    Joined:
    Apr 26, 2006
    Messages:
    12,486
    Likes Received:
    12,767
    Trophy Points:
    113
    Gender:
    Male
    Occupation:
    IT
    Location:
    Sweet Home Bingley.
    Style:
    Barnsley Dark
    Cheers chaps, I typed......

    =A1&amp;&quot;&quot;&amp;B1 in cell A3, then dragged A3 down all 300 rows. Sorted. Thanks</p>

    Couldn't get concatenate to work, though I am sure I have used it before.</p>
     
    Andy Mac, Feb 25, 2009
    #4

Share This Page