Help With Mconcat Formula

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

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,866
That worked great PaddyD, thanks. Someone else learned something too. LOL

Carbob
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,210
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,866
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,052
Messages
5,835,144
Members
430,342
Latest member
Sailingexcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top