concatenation and CHAR 10 copies to word with parenthesis

[brin]

I would like to know how to get rid rid of th parenthesis when it is copied to word

CONCATENATE(B5,C5&CHAR(10),B6,C6&CHAR(10),B7,C7&CHAR(10),B8,C8&CHAR(10),B9,C9&CHAR(10),B10,C10&CHAR(10),B11,C11&CHAR(10),B12,C12&CHAR(10),B13,C13&CHAR(10),B14,C14&CHAR(10),B15,C15&CHAR(10),B16,C16&CHAR(10),B17,C17&CHAR(10),B18,C18&CHAR(10),B19,C19,D19,E19,F19,G19,H19,I19&CHAR(10),B20,C20,D20,E20,F20,G20,H20,I20&CHAR(10),B21,C21,D21,E21,F21,G21,H21,I21)

"Type of Property: mixed farming.
Location: located XXX km XXX of XXX.
Surrounding development: similar rural country.

 

[Macropod]

If you mean the double-quote character at the start of the string, you could eliminate that by wrapping your existing formula in a SUBSTITUTE formula. For example:
=SUBSTITUTE(CONCATENATE(B5 ... I21),CHAR(34),"")

 

[brin]

Thanks Paul
Thats what I want to achieve-remove quotes from start and end of sentence.
I tried your formula but musn't have done it right
It showed a #NAME ? answer.

 

[JazzSP8]

#Name would suggest you've made a typo or something, it's the error for a Formula that isn't recognised :-/

To be clear you went with;

=SUBSTITUTE(CONCATENATE(B5,C5&CHAR(10),B6,C6&CHAR(10),B7,C7&CHAR(10),B8,C8&CHAR(10),B9,C9&CHAR(10),B10,C10&CHAR(10),B11,C11&CHAR(10),B12,C12&CHAR(10),B13,C13&CHAR(10),B14,C14&CHAR(10),B15,C15&CHAR(10),B16,C16&CHAR(10),B17,C17&CHAR(10),B18,C18&CHAR(10),B19,C19,D19,E19,F19,G19,H19,I19&CHAR(10),B20,C20,D20,E20,F20,G20,H20,I20&CHAR(10),B21,C21,D21,E21,F21,G21,H21,I21),CHAR(34),"")

?

 

[brin]

Thanks
I have used your formula exactly and it still ends up with quotes. I have gone back to the original formula that shows quotes.
I think that I was lookig at the wrong issue.
I have now found that both of the formulas copy to word OK without quotes. The problem is that I want to copy into a Company database that then shows quotes.
Maybe it reads it in Excel format.
I will check to see whether there is some other way that the data can be read.
I did'nt have problems before when i was copying from a word doc to the database.
Thanks for your help.