|
|
|
|
#1
02-14-2020, 08:40 AM
|
||||
|
||||
I'm guessing this is because your version of Excel doesn't support TEXTJOIN?
In the attached is a one-line user-defined function called txtjn which will do for your purposes, along with a tweak to the previous formula, which, like the previous one, needs to be array-entered (using Ctrl+Shift+Enter, not just Enter). See attached, cell E2 and below. 
|
|
| Tags |
| overlapping time and date, time overlap |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using equation editor for the first time | teacherguy | Word | 3 | 10-06-2017 05:13 PM |
| OneNote on Android phone View Tags? Enter Date, Time, Date & Time | DrTwinkyEsq | OneNote | 0 | 03-27-2017 07:54 PM |
 date & time of last time a recent file was used
|
pgeorgilas | Word | 1 | 10-31-2014 08:59 AM |
| Count the common time period (month) between two date period of time | Barni | Excel | 6 | 08-15-2014 07:52 AM |
|
Why copying a paragraph to an equation ends without equation format???
|
Jamal NUMAN | Word | 2 | 04-24-2011 06:18 AM |
Windows 10 
Office 2019
Hybrid Mode