1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Simple Excel Merging Question

Discussion in 'Business Applications' started by trailerparkboy, Jan 15, 2010.

Thread Status:
Not open for further replies.
Advertisement
  1. trailerparkboy

    trailerparkboy Thread Starter

    Joined:
    Jun 4, 2006
    Messages:
    35
    Hi,
    I have a spreadsheet with 2 columns: First Name, Last Name. All I need to do is have First Name Last Name together in one column.

    I tried selecting both columns and then use the Merge and Centre option, but this gives message that merging into one cell will keep left most data only (First Name only).

    I can't figure out this 'simple' task. Can anyone help me out?
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,987
    First Name:
    Wayne
    try using concatenate ( & ) in a new column

    = A1 & B1

    You can add a space between by doing this

    = A1 & " " & B1

    Then select the column
    do a COPY of the whole column
    Now
    Paste Special
    Past back the text
    Now you just have the names in the column and can delete the other two rows
     
  3. trailerparkboy

    trailerparkboy Thread Starter

    Joined:
    Jun 4, 2006
    Messages:
    35
    Thanks! Got it. Should have been able to figure that out.
     
  4. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,987
    First Name:
    Wayne
    (y) glad to have helped
    You can now mark as solved - use the button at the top of your first post
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/894366

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice