+ Reply to Thread
Results 1 to 1 of 1

Text Join with multiple delimiters

  1. #1
    Registered User
    Join Date
    11-22-2019
    Location
    Earth
    MS-Off Ver
    2016
    Posts
    1

    Text Join with multiple delimiters

    Hi,

    I want to TEXTJOIN a string of dates with a "-" delimiter between the date ranges and a "|" to separate the set of dates.

    A couple conditions:
    1) I want to be able to drag the formula down to pick up the date ranges
    2) I need to preserve the ddmmmyy date format
    3) I need the formula to skip blanks.

    The red font formula is where I'm stuck. I do not want the "|" delimiter to appear if the cells are blank, but can't quite figure it out.
    Is there a way to add a "-" between dates and "|" only if there's a value in the referenced cells?
    Any help is appreciated. Thanks!
    Attached Files Attached Files

+ 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. Macro to split large range of text with multiple delimiters.
    By QUAKE2K in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 11-06-2019, 10:35 AM
  2. Join text of variable lengths from multiple rows
    By excobra in forum Excel General
    Replies: 6
    Last Post: 07-26-2018, 03:38 PM
  3. Split text into array using multiple delimiters
    By TKFRMjarvis in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-26-2014, 03:07 PM
  4. [SOLVED] Sort Text into Rows by Multiple Delimiters/Values
    By BoostThis in forum Excel General
    Replies: 6
    Last Post: 11-22-2013, 12:31 PM
  5. Use of multiple delimiters under Text To Columns
    By ryandonn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-20-2013, 03:05 PM
  6. join text from multiple cells to one cell
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2009, 06:28 PM
  7. Use of multiple-character delimiters under Text To Columns
    By longtalker in forum Excel General
    Replies: 3
    Last Post: 03-16-2009, 06:00 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