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.

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?
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"lehigh46" wrote:

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.

On Wed, 23 Jul 2008 08:35:58 -0400, lehigh46 wrote:

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

Ron,
What is MConCat? I can't find it in the list of functions for 2003. Is
it new to 2007?
--
Hope to hear from you soon.
Sincerely,
Gary Brown


"Ron Rosenfeld" wrote:

On Wed, 23 Jul 2008 08:35:58 -0400, lehigh46 wrote:

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

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


Gary Brown wrote:

Ron,
What is MConCat? I can't find it in the list of functions for 2003. Is
it new to 2007?
--
Hope to hear from you soon.
Sincerely,
Gary Brown

"Ron Rosenfeld" wrote:

On Wed, 23 Jul 2008 08:35:58 -0400, lehigh46 wrote:

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


--

Dave Peterson

lehigh46 wrote...
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.

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.
--
Sincerely,
Gary Brown


"Dave Peterson" wrote:

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


Gary Brown wrote:

Ron,
What is MConCat? I can't find it in the list of functions for 2003. Is
it new to 2007?
--
Hope to hear from you soon.
Sincerely,
Gary Brown

"Ron Rosenfeld" wrote:

On Wed, 23 Jul 2008 08:35:58 -0400, lehigh46 wrote:

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


--

Dave Peterson

On Wed, 23 Jul 2008 11:46:21 -0700, Gary Brown
wrote:

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