#name?

[CARBOB]

In Columns AJ,AK,AL are formulas that use MCONCAT. The workbooks shows the Add-in is installed but formula not working. I have tried everything I know about Excel, would appreciate help very much. Thanks




https://app.box.com/s/yki9itjb55v44gygvwde9b5jo19l8ql4

 

[sheetspread]

The box is checked in add-ins too? Are you using 64 bit? Look here also:

https://www.mrexcel.com/forum/excel-questions/683917-aconcat-mconcat-functions.html

 

[CARBOB]

The box is checked in add-ins too? Are you using 64 bit? Look here also:

https://www.mrexcel.com/forum/excel-questions/683917-aconcat-mconcat-functions.html

I tried all the suggestions, morefunc11 & morefunc12 are stored in Program files(x86) and the box is check in add-tools box. Before upgrading to W10 Excel worked perfect.

 

[Aladin Akyurek]

You can either use the new native function TEXTJOIN or Grove's ACONCAT, written in VBA instead of Longre's venerable MCONCAT.

 

[CARBOB]

You can either use the new native function TEXTJOIN or Grove's ACONCAT, written in VBA instead of Longre's venerable MCONCAT.

Thanks Aladin


I am a greenhorn please bear with me. Do I create a macro? Then what?

 

[sheetspread]

If you have Excel 2016 there's a textjoin function that does this. Otherwise go to the visual basic editor, insert a module, paste the code from the link above, and the function =aconcat will work.

 

[CARBOB]

If you have Excel 2016 there's a textjoin function that does this. Otherwise go to the visual basic editor, insert a module, paste the code from the link above, and the function =aconcat will work.

Do I enter this entire text in the module?

Function aconcat(a As Variant, Optional sep As String = "") As String
' Harlan Grove, Mar 2002
Dim y As Variant
If TypeOf a Is Range Then
For Each y In a.Cells
aconcat = aconcat & y.Value & sep
Next y
ElseIf IsArray(a) Then
For Each y In a
aconcat = aconcat & y & sep
Next y
Else
aconcat = aconcat & a & sep
End If
aconcat = Left(aconcat, Len(aconcat) - Len(sep))
End Function

 

[Aladin Akyurek]

yes.

alt + F11

insert module

copy the function code and paste it in the pane you get from the previou step

file >> close and return to microsoft excel

once done, now you can use in the stead of mconcat

 

[CARBOB]

yes.

alt + F11

insert module

copy the function code and paste it in the pane you get from the previou step

file >> close and return to microsoft excel

once done, now you can use in the stead of mconcat

Instead of #NAME # I get a #Value !

 

[sheetspread]

Are you able to get it working on a simple data set before combining with other functions?