Help With Mconcat Formula

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Joe Was

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539
Do you mean:

CONCATENATE (text1,text2,...)

or

= A1 & B1

"MCONCAT" I never heard of?
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
Hi Joe,

""MCONCAT" I never heard of?"

..part of morefunc addin.
 

Joe Was

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539

ADVERTISEMENT

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

CARBOB

Well-known Member
Joined
Jun 6, 2005
Messages
1,860
That worked great PaddyD, thanks. Someone else learned something too. LOL

Carbob
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
PaddyD said:
=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

Well-known Member
Joined
Jun 6, 2005
Messages
1,860
Aladin Akyurek said:
PaddyD said:
=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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,167
Messages
5,570,635
Members
412,334
Latest member
ExcelForLifeDontHate
Top