+ Reply to Thread
Results 1 to 5 of 5

Combining values from 2 columns into 1 without spaces

  1. #1
    Forum Contributor Saeber4777's Avatar
    Join Date
    06-06-2014
    Location
    United States
    MS-Off Ver
    365 Enterprise
    Posts
    159

    Combining values from 2 columns into 1 without spaces

    I have searched everywhere trying to find a formula to combine column a and b values to column c without spaces. All i can find is:

    Please Login or Register  to view this content.
    The problem is when i adapt the formula for use in my worksheet, it only returns column a.

    There may be repeating values in column b that already exist in column a. I don't want to pull repeats or blanks. Any help is appreciated.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Combining values from 2 columns into 1 without spaces

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor Saeber4777's Avatar
    Join Date
    06-06-2014
    Location
    United States
    MS-Off Ver
    365 Enterprise
    Posts
    159

    Re: Combining values from 2 columns into 1 without spaces

    Here it is
    Attached Files Attached Files

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Combining values from 2 columns into 1 without spaces

    maybe use PowerQuery
    • no spaces
    • no duplicates
    • no formula(s)
    • sorted

  5. #5
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Combining values from 2 columns into 1 without spaces

    If you prefer a formula solution, I think the following will work - paste the formula below in C2, it should be array-entered (confirm with Ctrl+Shift+Enter instead of Enter), then fill down:

    =IFERROR(IFERROR(INDEX($A$2:$A$252,SMALL(IF($A$2:$A$252<>"",ROW($A$2:$A$252)-ROW($A$2)+1),ROW(1:1))),INDEX($B$2:$B$252,SMALL(IF(COUNTIF($A$2:$A$252,$B$2:$B$252)=0,ROW($B$2:$B$252)-ROW($B$2)+1),ROW(1:1)-COUNTIF($A$2:$A$252,"?"&"*")))),"")

    It should list everything in A followed by everything in B that's not in A. Take a look at the attachment to see if it works for you:
    Attached Files Attached Files
    If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".

    If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
    https://www.excelforum.com/the-water...ke-thread.html

+ 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. [SOLVED] URGENT - Combining Values In 2 Columns
    By imcdonaghw in forum Excel General
    Replies: 2
    Last Post: 02-26-2018, 06:37 AM
  2. [SOLVED] Combining list of Unique Values from Multiple Columns and with Total Value
    By masood78 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-11-2016, 07:27 PM
  3. [SOLVED] vba to split the cell values text to columns with undelimited spaces
    By MicroTees in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2016, 06:47 AM
  4. String combining column names. Extract values from these columns.
    By regresss in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2015, 06:20 PM
  5. Combining values from multiple columns into one
    By dylanvv in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-11-2014, 05:41 PM
  6. [SOLVED] Combining values from two different columns
    By smonzon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2012, 11:56 PM
  7. Quick question...combining columns of values
    By Scot B in forum Excel General
    Replies: 2
    Last Post: 12-26-2005, 10:35 PM

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