MCONCAT

[lehigh46]

Hi All,

I have a list of hand typed subjects in column B2 thru B20
I use MCONCAT to group them into cell B1

I now have the need to bring in the subjects via VLOOKUP.
Obviously, MCONCAT will not group formulas.

Any suggestions?

Thanks for your help in advance.

 

[Gary Brown]

I think MConcat( ) may be a user-defined function. As far as I know, it is
not an Excel 2003 or earlier function.
That said, if you put the subjects into Col C and 'mconcat' both columns,
will it do what you want?

 

[Ron Rosenfeld]

Hi All,

I have a list of hand typed subjects in column B2 thru B20
I use MCONCAT to group them into cell B1

I now have the need to bring in the subjects via VLOOKUP.
Obviously, MCONCAT will not group formulas.

Any suggestions?

Thanks for your help in advance.

Can you explain more clearly what you want to do?

If the formulas return strings, you could certainly use MCONCAT.
--ron

 

[Gary Brown]

Ron,
What is MConCat? I can't find it in the list of functions for 2003. Is
it new to 2007?

 

[Dave Peterson]

It could be a function in Laurent Longre's addin (morefunc.xll) at:
http://xcell05.free.fr/
http://xcell05.free.fr/morefunc/english/mconcat.htm

 

[Harlan Grove]

I have a list of hand typed subjects in column B2 thru B20
I use MCONCAT to group them into cell B1

I now have the need to bring in the subjects via VLOOKUP.
Obviously, MCONCAT will not group formulas.

Any suggestions?

First, presumably you mean the MCONCAT function from Laurent Longre's
MOREFUNC.XLL add-in.

Unclear what your VLOOKUP calls are like or what they'd return. If
your VLOOKUP calls return the values from a 19 row by 1 column range,
you could replace them with a single INDEX(..,MATCH(..)) call, then
use that as the argument to MCONCAT.

If you need more details, PROVIDE MORE DETAILS FIRST.

 

[Gary Brown]

Thanks Dave. That makes sense.
I'd written one like that called ConcatenateALL but I like MConcat better.
Easier to type :O>
Have a good one.

 

[Ron Rosenfeld]

Ron,
What is MConCat? I can't find it in the list of functions for 2003. Is
it new to 2007?
--

It is a function from Laurent Longre's morefunc.xll add-in (presumably):

MCONCAT
Concatenates all data in a range or an array.

SYNTAX :
=MCONCAT(Array,Separators)

- Array : range or array. All data types are supported.

- Separators (string, optional) : one or more characters separating the items
in the concatenated string.

MCONCAT concatenates the items from left to right and from top to bottom. For
instance, =MCONCAT(A1:C3) returns the same string as
=A1&B1&C1&A2&B2&C2&A3&B3&C3.

EXAMPLES :
The range "PL" (5 rows * 4 columns) containing the integers 1 to 20 :

=MCONCAT(PL) returns "1234567891011121314151617181920"

=MCONCAT(PL," ") returns "1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20"
--ron