+ Reply to Thread
Results 1 to 3 of 3

How to Merge Two Columns of Data into One?

  1. #1
    Registered User
    Join Date
    03-23-2006
    Posts
    28

    How to Merge Two Columns of Data into One?

    This one should be pretty simple, I just can't remember how to do it. Column A has all first names and column B has all last names. How do I merge the two into a single column that has both the first name form column A AND the last name from column B?

    Thanks!

  2. #2
    Registered User
    Join Date
    06-08-2006
    Location
    Portland, OR
    MS-Off Ver
    Micro Soft XP, Excel 2003
    Posts
    97

    Merge text in two columns

    in cell c1 enter the following

    =CONCATENATE(A1," ",B1)

    Lostinformulas

  3. #3
    Registered User
    Join Date
    08-27-2006
    Posts
    5

    Merge 2 cols

    You can also use the following in c1:

    =a1 & " " & b1

+ 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