Combine data in two different cells into one in Excel

by Michelle Mangen on November 23, 2009

in Excel Tips & How-To

Combining two different cells in Excel to have all info in one cell

This Excel formula is really handy, especially if you have a first and last name in two different cells and want to combine them into just one cell so instead of:

  • Column A=First Name
  • Column B=Last Name
  • You will now have Column C=First name and last name

Once you are finished with the “merge” (not a true merge by Excel standards). You will most likely want to delete your original columns but need to have that data as constant data instead of formulated data.

Video Tutorial:

How to combine your data from two different cells into one:

  • In a blank column enter in the following formula: A2&” “&B2 (This is presuming your data is starting in Row 2)
  • **NOTE** there is a space between the “quote marks” in the formula above
  • Copy this formula down into all other applicable cells
  • You are finished!

Okay, want to make that data constant so you can delete your original columns (in this case Column A & B)?

  • Make sure you have a blank column to put the data
  • Highlight the entire column with the combined data>Copy
  • Move to appropriate blank cell in the new, blank column you just inserted
  • Right Click and Chose “Paste Special” >then chose “Values”

When you delete Columns A&B you will see the data in Column D (in this example) is still intact.

Reblog this post [with Zemanta]

Have you been wondering "How Do I Start A Virtual Assistant Business? or "How To Find Virtual Assistant Jobs?".

  • Pingback: Inner City Bike â?? Bicicleta Fara Lant | it Now « Naruto()

  • Pingback: Tweets that mention Combine data in two different cells into one in Excel --

  • dave@home improvements

    Very informative video, extremely easy to follow and understand. When someone tries to explain something by typing I can never get it, videos are the way ! :)
    .-= dave@home improvements´s last blog ..How To Fix a Leaking Faucet =-.

    • Michelle Mangen

      Dave – thanks for the comment. With the Excel tips I have found them to be more useful when they are video vs just typing. Thank you for the comment. I really appreciate it. And I’m totally going to stop by your blog as I love to find contractors using the internet to market! So hats off to you!

  • fake security cameras

    thanks for the useful tips here. I have a home improvement blog that I work really hard on like you are doing here. My efforts skew towards a lot of general topics and hopefully give high level answers for what folks are looking for. Keep on doing a nice job with your site

  • jean@basic bookkeeping courses

    Sounds very simple. I have been doing data entry works and I really need to be proficient in excel and this video is a good help. Thanks for taking the time to make a tutorial video.
    .-= jean@basic bookkeeping courses´s last blog ..Dec 15, Online Bookkeeping Courses =-.

    • Michelle Mangen

      Jean – absolutely! It’s my intent to have at least one how to video on Excel each week in 2010. I have so many of them running around in my head…it’s just a matter of taking the time to record all of them and uploading to YouTube.

  • edward@digital slr camera

    simple and clearly explained, now i know a solution for this excell problem.
    .-= edward@digital slr camera´s last blog ..How to Enter and Winning in Photography Contest =-.

  • Pingback: Your Virtual Assistant: Weekly Round-Up No. 2()

  • Handyman Services

    i had the same issue with my worksheet, thanks for the video, it solved my problem. appreciate that.

  • Pingback: Your Virtual Assistant: Weekly Round-Up No. 1()

  • ms excel training

    Very well
    explained post.Simple but descriptive.It has earned place in my bookmarks
    now. Thanks for sharing.I appreciate your writing skills.

  • Anonymous

    for this blog.Really i get a idea how we can work on excel

  • Anonymous

    Its a knowledgeable information for me.I get some extra knowledge from this content.Thanks to share this blog

Previous post:

Next post: