+ Reply to Thread
Results 1 to 3 of 3

How to combine merge two columns?

  1. #1
    Registered User
    Join Date
    07-22-2013
    Location
    brisbane,australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question How to combine merge two columns?

    I have two columns of text that I want to combine (but not concatentate) e.g.

    The first column has no nulls but I want to replace wqith a value from column two.
    Column two has nulls but I dont want to overwrite column 1 with these nulls i.e. I want to keep column 1 text.

    Please see attached example.

    I hvae minimal experience with this kind of excel problem.

    Thanks

    M
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: How to combine merge two columns?

    hi muzz001. welcome to the forum. you mean?
    =IF(B2="",A2,B2)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    07-22-2013
    Location
    brisbane,australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How to combine merge two columns?

    Thanks benishiryo, that does the job

    cheers

    M

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Is it possible to combine/merge images?
    By MrFletcher in forum Excel General
    Replies: 14
    Last Post: 04-15-2020, 12:46 PM
  2. Merge duplicate rows and combine data in some of the same columns
    By Ken.runciman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2013, 11:43 PM
  3. [SOLVED] Merge duplicate rows and merge the columns (approx 10 columns)
    By adfeddon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-02-2012, 11:19 AM
  4. Replies: 0
    Last Post: 09-29-2011, 04:58 PM
  5. [SOLVED] How to Combine or Merge Columns?
    By Shani in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2006, 10:10 AM

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