convert matrix to a string

  • Thread starter Thread starter Patrick Webb
  • Start date Start date
P

Patrick Webb

I want to convert a matrix array into a string column,
that is, convert the first row into a column string, then
the second row below the first and so on
 
I don't understand what you mean by "string column" or "column string". Can you give an example
of the input and desired output?
 
Huh? Perhaps you provide an illustration of what you're starting with
and what you expect to end with.

Alan Beban
 
I want to convert a matrix array into a string column,
that is, convert the first row into a column string, then
the second row below the first and so on
Click to expand...

Since others are afraid to guess, I'll take a chance. Do you mean something like
starting with a 4-row by 3 column range containing

a b c
d e f
g h i
j k l

and generating a 4-row by 1 column range containing

abc
def
ghi
jkl

? If so, Excel provides no built-in functionality to do this in a general way.
If the first table above were in A1:C4, you could construct the 'abc' result
using the formula

=A1&B1&C1

Would that be sufficient? If not, and if you need *concatenation* formulas that
can handle arbitrary range references, you'll need and add-in or a user-defined
function to do this. The ideal solution would be downloading and installing
Laurent Longre's MOREFUNC.XLL add-in, available at

http://longre.free.fr/english/

This add-in contains a function called MCONCAT that would do what I believe
you're trying to do.

On the other hand, maybe you're looking for TRANSPOSE. You do need to be more
precise, and a simplified example wouldn't hurt.
 
I'm kind of surprised that you don't suggest that they post via CDO, but search
for answers via google.

But even if you did, if they couldn't find it (via CDO), you'd be preaching to
the wind.
 
I thought google had like a 6 hr delay or more.

Might not be practical unless they are willing to go day at a time.

Regards,
Tom Ogilvy
 
Gotcha on my followup!

Tom said:
I thought google had like a 6 hr delay or more.

Might not be practical unless they are willing to go day at a time.

Regards,
Tom Ogilvy
Click to expand...
<<snipped>>
 
Back
Top