Help With Mconcat Formula

[CARBOB]

Using the formula in Col "B" to read the 3-digit number in Col "A". Using 0,1,2,3,4= L and 5,6,7,8,9 = H B2 should be LLL,B3 LHH, B5 LHL
B6 LHH

Carbob

DOUBLESMIRRORSTOTALSMASTER A.xls
	A	B	C	D
2	243	LLL		9
3	459	LLL		18
4	404	LLL		8
5	394	LLL		16
6	358	LLL		16
FILTERS

 

[PaddyD]

=MCONCAT(IF(--(MID(A2,{1,2,3},1))<5,"L","H"))

 

[Joe Was]

Do you mean:

CONCATENATE (text1,text2,...)

or

= A1 & B1

"MCONCAT" I never heard of?

 

[PaddyD]

Hi Joe,

""MCONCAT" I never heard of?"

..part of morefunc addin.

 

[Joe Was]

Thanks I forgot about that addin. Only used "VSORT" from it, most of the others I just write my own code for.

 

[CARBOB]

That worked great PaddyD, thanks. Someone else learned something too. LOL

Carbob

 

[Aladin Akyurek]

=MCONCAT(IF(--(MID(A2,{1,2,3},1))<5,"L","H"))

The latest version introduces the so-called REGEX functions:

=REGEX.SUBSTITUTE(REGEX.SUBSTITUTE(A2,"0|1|2|3|4","L"),"5|6|7|8|9","H")

CARBOB:

Why don't you invoke in D2:

=SUM((MID(A2,{1,2,3},1)+0))

 

[CARBOB]

=MCONCAT(IF(--(MID(A2,{1,2,3},1))<5,"L","H"))

The latest version introduces the so-called REGEX functions:

=REGEX.SUBSTITUTE(REGEX.SUBSTITUTE(A2,"0|1|2|3|4","L"),"5|6|7|8|9","H")

CARBOB:

Why don't you invoke in D2:

=SUM((MID(A2,{1,2,3},1)+0))

Thanks Aladin, I will do that.
Carbob