concatenate problem

[tarmand]

I'm trying to make three rows in a column join together to make one.

For instance, I want to take cells A5, A6, & A7, combine them into one and put it in A8 separated by a space.

I want to copy that through column Y

Some rows don't have any information in them.

I tried using

=mconcat(A5:A7," ")

and I got this as a result

#NAME?

Any advice?

 

[fairwinds]

Hi,

MCONCAT belongs to morefunc add-in that you need to download from
http://longre.free.fr/english/index.html

But with only 3 cells to concatenate, maybe =CONCATENATE() would do?

 

[Brian from Maui]

I'm trying to make three rows in a column join together to make one.

For instance, I want to take cells A5, A6, & A7, combine them into one and put it in A8 separated by a space.

I want to copy that through column Y

Some rows don't have any information in them.

I tried using

=mconcat(A5:A7," ")

and I got this as a result

#NAME?

Any advice?

Have you got the Morefunc addin installed?

 

[tarmand]

Thanks. I didn't realize I had to install something. I did go ahead and use the concatenate and it worked. Thanks again.