+ Reply to Thread
Results 1 to 4 of 4

[SOLVED] I want to merge two columns

  1. #1
    Andrew
    Guest

    [SOLVED] I want to merge two columns

    Hi, My problem is that I have two colums of data in a worksheet, the first is
    a prefix to the part number
    i.e. AB
    The second is a part number
    i.e. 123456789

    My list is 8800 numbers long and I want a quick way to merge these comuns
    together but keep the rows.

    Thankyou in advance,
    Andrew

    P.S. don't know if it's important but running XP Pro SP2 and Office 2003

  2. #2
    Anne Troy
    Guest

    Re: I want to merge two columns

    Hi, Andrew. Here ya go:
    --click the column letter to the RIGHT of your 2 columns and hit
    Insert-->Column.
    --select the new blank column and make sure it's formatted as General
    --in the new blank column, probably the 2nd row if you have headings, type
    =A2&B2
    Copy down using the fill handle:
    http://www.officearticles.com/excel/...soft_excel.htm
    Then, with all the cells STILL selected, hit Copy. Hit Edit-->Paste Special,
    choose Values, OK.
    Then delete your original columns.
    ************
    Anne Troy
    www.OfficeArticles.com

    "Andrew" <Andrew@discussions.microsoft.com> wrote in message
    news:7D51C6B8-C915-4021-A008-86A66BA5454D@microsoft.com...
    > Hi, My problem is that I have two colums of data in a worksheet, the first
    > is
    > a prefix to the part number
    > i.e. AB
    > The second is a part number
    > i.e. 123456789
    >
    > My list is 8800 numbers long and I want a quick way to merge these comuns
    > together but keep the rows.
    >
    > Thankyou in advance,
    > Andrew
    >
    > P.S. don't know if it's important but running XP Pro SP2 and Office 2003




  3. #3
    Andrew
    Guest

    Re: I want to merge two columns

    Thankyou Anne for your help, problem solved

    "Anne Troy" wrote:

    > Hi, Andrew. Here ya go:
    > --click the column letter to the RIGHT of your 2 columns and hit
    > Insert-->Column.
    > --select the new blank column and make sure it's formatted as General
    > --in the new blank column, probably the 2nd row if you have headings, type
    > =A2&B2
    > Copy down using the fill handle:
    > http://www.officearticles.com/excel/...soft_excel.htm
    > Then, with all the cells STILL selected, hit Copy. Hit Edit-->Paste Special,
    > choose Values, OK.
    > Then delete your original columns.
    > ************
    > Anne Troy
    > www.OfficeArticles.com
    >
    > "Andrew" <Andrew@discussions.microsoft.com> wrote in message
    > news:7D51C6B8-C915-4021-A008-86A66BA5454D@microsoft.com...
    > > Hi, My problem is that I have two colums of data in a worksheet, the first
    > > is
    > > a prefix to the part number
    > > i.e. AB
    > > The second is a part number
    > > i.e. 123456789
    > >
    > > My list is 8800 numbers long and I want a quick way to merge these comuns
    > > together but keep the rows.
    > >
    > > Thankyou in advance,
    > > Andrew
    > >
    > > P.S. don't know if it's important but running XP Pro SP2 and Office 2003

    >
    >
    >


  4. #4
    Anne Troy
    Guest

    Re: I want to merge two columns

    Cool beans! Thanks for the feedback.
    ************
    Anne Troy
    www.OfficeArticles.com

    "Andrew" <Andrew@discussions.microsoft.com> wrote in message
    news:671AD8CC-CD6E-41E8-A1FD-495942A25C6C@microsoft.com...
    > Thankyou Anne for your help, problem solved
    >
    > "Anne Troy" wrote:
    >
    >> Hi, Andrew. Here ya go:
    >> --click the column letter to the RIGHT of your 2 columns and hit
    >> Insert-->Column.
    >> --select the new blank column and make sure it's formatted as General
    >> --in the new blank column, probably the 2nd row if you have headings,
    >> type
    >> =A2&B2
    >> Copy down using the fill handle:
    >> http://www.officearticles.com/excel/...soft_excel.htm
    >> Then, with all the cells STILL selected, hit Copy. Hit Edit-->Paste
    >> Special,
    >> choose Values, OK.
    >> Then delete your original columns.
    >> ************
    >> Anne Troy
    >> www.OfficeArticles.com
    >>
    >> "Andrew" <Andrew@discussions.microsoft.com> wrote in message
    >> news:7D51C6B8-C915-4021-A008-86A66BA5454D@microsoft.com...
    >> > Hi, My problem is that I have two colums of data in a worksheet, the
    >> > first
    >> > is
    >> > a prefix to the part number
    >> > i.e. AB
    >> > The second is a part number
    >> > i.e. 123456789
    >> >
    >> > My list is 8800 numbers long and I want a quick way to merge these
    >> > comuns
    >> > together but keep the rows.
    >> >
    >> > Thankyou in advance,
    >> > Andrew
    >> >
    >> > P.S. don't know if it's important but running XP Pro SP2 and Office
    >> > 2003

    >>
    >>
    >>




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1