I want to display two cells contents together in another cell. It is easy with one cell, just use = and it is okey. But, can we display two or more cells together in one cell?
You can concatenate the contents of several cells using & Example: A1=Bad B1=Dog C1=A1&B1 = BadDog If you want to add a space between two text Values you need to type C1=A1&" "&B1 = Bad Dog (it's a space between the double quotes)
In addition to the above answer: there is the CONCATENATE function, which is what I used so far, before seeing Pedro's answer.
Why use it as it is longer but seems to do the same? Discover-ability (for me) and being more explicit in what you are doing; would consider keeping CONCATENATE for macro's, for example.
True, that's why, just like with your answer, where you add '& " " &' for a space in between the cell references, you'd have to concatenate a space before every next word apart from the first one. As I said: functionally the same, but more verbose. I' be mostly using 'your' & way in future.
bosyber ( 2012-03-01 21:27:06 +0200 )editLibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-02-26 10:16:33 +0200
Seen: 2,080 times
Last updated: Mar 01 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
