+ Reply to Thread
Results 1 to 4 of 4

Join Cells using TEXTJOIN

  1. #1
    Registered User
    Join Date
    02-25-2010
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    2

    Join Cells using TEXTJOIN

    Can someone help please, I have multiple faults that come to me and they can all be different, sometimes all six cells have info, others could have three, four or five depending on the issue. The first two always remain the same, I need to combine cells A3:A6 but I don’t want the cell with “Defect Codes: ........” wether it be A4, A5, A6 so my results would be for example 1
    Gauge Issue, Poor Top, Ineffective Clips
    and example 2
    Poor Top, Ineffective Clips
    I’ve used TEXTJOIN to get so far but can’t work out how to remove the other cells be it blank or with “Defect Codes”

    Thanks in advance for any help.

    Example 1
    A1 Priority: 1
    A2 Fault Number:
    A3 Gauge Issue
    A4 Poor Top
    A5 Ineffective Clips
    A6 Defect Codes: RA13,TG13,SL08

    Example 2
    A1 Priority: 2
    A2 Fault Number:
    A3 Poor Top
    A4 Ineffective Clips
    A5 Defect Codes: TG13,SL08
    A6
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Join Cells using TEXTJOIN

    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-25-2010
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Join Cells using TEXTJOIN

    Thank you soooo much, that’s perfect

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Join Cells using TEXTJOIN

    You're welcome & thanks for the feedback.

+ 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. CONCAT/TEXTJOIN on Variable Number of Cells
    By OlYeller21 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-10-2019, 06:29 AM
  2. TEXTJOIN array for cells with functions in them (bug?)
    By Allerdrengen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-02-2018, 05:24 AM
  3. [SOLVED] Join values of 4 cells
    By stojko89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2017, 12:57 AM
  4. [SOLVED] Excel 2007 : join cells with 00 values
    By maria a in forum Excel General
    Replies: 12
    Last Post: 06-16-2012, 11:56 AM
  5. Join data in two cells
    By nvsanilkumar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2012, 03:57 AM
  6. How do I join a range of cells?
    By BPB in forum Excel General
    Replies: 1
    Last Post: 04-12-2006, 01:50 PM
  7. join cells for a vlookup
    By Jim in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-25-2006, 11:15 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