Results 1 to 12 of 12

TextJoin formula with MID function

Threaded View

  1. #1
    Registered User
    Join Date
    02-11-2018
    Location
    Germany
    MS-Off Ver
    Office 2007
    Posts
    22

    Post TextJoin formula with MID function

    I tried to run this formula in excel
    =TEXTJOIN(",",TRUE,IF(MID($EP3:$ET3,2,255<=6),LEFT($EP3:ET3,1),""))
    but it returns #Value! error. Here in the range EP3:ET3, I have values like (L1,L2,R1,R22,R30) etc. basically alphanumeric values.
    and according to the digital values I try to group letters together with textjoin which I couldn't make it work.

    Can you help me with the formula what is wrong with it, or suggest me an alternative, please? Thanks.
    Attached Files Attached Files
    Last edited by Brsth; 04-25-2018 at 02:04 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Removing duplicates from a TEXTJOIN
    By CKPHarry in forum Excel General
    Replies: 5
    Last Post: 01-02-2020, 05:57 PM
  2. [SOLVED] Converting TEXTJOIN to CONCATENATE
    By mattmccormack1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-22-2018, 05:46 PM
  3. Textjoin sometimes works well and sometimes doesnot
    By leprince2007 in forum Office 365
    Replies: 36
    Last Post: 04-03-2018, 07:11 AM
  4. Textjoin?
    By johandenver in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 10-01-2017, 03:18 PM
  5. TEXTJOIN only specific words
    By thoart in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-11-2017, 07:56 AM
  6. If Match then return TEXTJOIN
    By Cynops in forum Excel General
    Replies: 1
    Last Post: 11-09-2016, 07:51 AM
  7. TEXTJOIN function
    By Tony Valko in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-13-2016, 06:48 PM

Tags for this Thread

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