Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    May 2003
    Location
    Mid-Cheshire, England
    Posts
    275
    Thanks
    1
    Thanked 3 Times in 3 Posts
    Using MS Excel 2000

    My worksheet has 400+ rows. In column A are first names and last names are in column B. I want to have first and last names in one column. Is there a way to do this other than manually?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='MalcolmWalker' post='773349' date='01-May-2009 22:46']Using MS Excel 2000

    My worksheet has 400+ rows. In column A are first names and last names are in column B. I want to have first and last names in one column. Is there a way to do this other than manually?[/quote]

    Hi Malcolm

    In cell C1 type:

    = A1 & " " & B1

    And copy down using the fill handle to C400 +
    Jerry

  3. #3
    3 Star Lounger
    Join Date
    May 2003
    Location
    Mid-Cheshire, England
    Posts
    275
    Thanks
    1
    Thanked 3 Times in 3 Posts
    [quote name='Jezza' post='773350' date='01-May-2009 22:51']Hi Malcolm

    In cell C1 type:

    = A1 & " " & B1

    And copy down using the fill handle to C400 +[/quote]

    Thank you - That's works fine. But there's a BUT!

    When I copy and paste column C into a new worksheet the first and last names are replaced by #REF! Having achieved the object is it possible to remove the dependence on the formula?

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='MalcolmWalker' post='773353' date='01-May-2009 23:03']Thank you - That's works fine. But there's a BUT!

    When I copy and paste column C into a new worksheet the first and last names are replaced by #REF! Having achieved the object is it possible to remove the dependence on the formula?[/quote]


    Not a problem, copy column C and then in the new worksheet select the range and click EDIT---> Paste Special and then select Values

    This converts it for you.....
    Jerry

  5. #5
    3 Star Lounger
    Join Date
    May 2003
    Location
    Mid-Cheshire, England
    Posts
    275
    Thanks
    1
    Thanked 3 Times in 3 Posts
    [quote name='Jezza' post='773354' date='01-May-2009 23:09']Not a problem, copy column C and then in the new worksheet select the range and click EDIT---> Paste Special and then select Values

    This converts it for you.....[/quote]

    That solves the whole issue for me. Thank you very much for your assistance. The drinks are on me when we meet!

    Malcolm

Posting Permissions

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