TextJoin formula with MID function

I tried to run this formula in excel

Please Login or Register  to view this content.

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.

Need to see some data in context.

To attach a file to your post,

• be sure to desensitize the data
• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.

TEXTJOIN() - This feature is only available if you have an Office 365 subscription.

so maybe update excel version(s) on your profile and add 3 letters: Mac
and say in the first post , your textjoin function is UDF not build-in

btw. your example file doesn't contain any VBA code with TEXTJOIN

=TEXTJOIN(",",TRUE,IF(--MID($EP3:$ET3,2,255)<=6,LEFT($EP3:ET3),""))
maybe this but I really don't know. I corrected your formula only
or
with your textjoin: IF(--MID($A2:$E2,2,1)<=6,LEFT(A2:E2),"") and CSE

Excel 2016 (Windows) 64 bit

	A	B	C	D	E	F	G	H
1	DATA						FROM 1 - 6	FROM 7 - 12
2	L8	L9	R1	R2	R7		R,R	L,L,R
3	L18	R5	R7	R8	R12		R	L,R,R,R
4	L2	L4	S12	S13	R15		L,L	S,S,R
5	L9	L11	L3	L6	R1		L,L,R	L,L
6	L15	G2	R5	R9	R11		G,R	L,R,R
7	L14	L7	L10	L4	R3		L,R	L,L,L
8	L17	L8	L2	K5	R14		L,K	L,L,R
9	L14	L17	L18	L2	R12		L	L,L,L,R
10	L9	L10	D3	R9	R13		D	L,L,R,R
11	L13	L11	K7	R10	R12			L,L,K,R,R
12	L5	R2	K3	R14	R16		L,R,K	R,R
13	L8	L9	L4	R7	R11		L	L,L,R,R
14	L18	M11	L2	L5	R11		L,L	L,M,R
15	L9	L10	F4	R11	R16		F	L,L,R,R
16	L9	L12	L4	C1	R8		L,C	L,L,R

Sheet: Sheet1

G2

Formula:

Please Login or Register  to view this content.

H2

Formula:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Another way if you are open to VBA solution.

Install this code (by tigeravatar) in the VBA editor and save file as *xlsm macro enabled file. It is a user defined function called Concatall.

Please Login or Register  to view this content.

Then array enter this formula in the first row and fill down.

Formula:

Please Login or Register  to view this content.

In the other column array enter this and fill down.

Formula:

Please Login or Register  to view this content.