Concatenate

[carl]

I have 250 cells like so:

..
..
..
N137&
N138&
N139&
N140&
N141&
N142&
N143
..
..
..

I would like to copy these cells and place them into 1
cell as a formula... =N137&N138....

Is there a easy way to do this ?

Thank you in advance

 

[Juan Pablo González]

Using MoreFunc.xll (http://longre.free.fr/english)

=MCONCAT(A1:A20)

will create the string. I believe you could also use

=EVAL(MCONCAT(A1:A20))

to actually evaluate the formula.

 

[carl]

Thankyou. I downloaded the file. What do I do next ?