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,490
    Likes Received:
    12,771
    Trophy Points:
    113
    Gender:
    Male
    Occupation:
    IT
    Location:
    Sweet Home Bingley.
    Style:
    Barnsley Dark
    #1 Andy Mac, Feb 25, 2009
    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>
     
  2. Gue

    Guest Guest

    #2 Guest, Feb 25, 2009
    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.
     
  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)
    #3 BrunNer, Feb 25, 2009
    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.
     
  4. Andy Mac

    Andy Mac Well-Known Member

    Joined:
    Apr 26, 2006
    Messages:
    12,490
    Likes Received:
    12,771
    Trophy Points:
    113
    Gender:
    Male
    Occupation:
    IT
    Location:
    Sweet Home Bingley.
    Style:
    Barnsley Dark
    #4 Andy Mac, Feb 25, 2009
    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>
     
(You must log in or sign up to post here.)

Share This Page