Combine Cells in a column onto one cell

[Emmanuel]

I have value in different columns in the same row. I wish
to combine into one cell also in the same row. It is like
concatenating diffrent string values on one string,
dropping the trailing spaces. How can I do it please?

Of course if I can do from one row I could hopefully do it
over a range of rows?

Emmanuel

 

[Don Guillett]

Not real clear but
=a1+b1+c1
or
=trim(a1)+trim(b1)
or
=trim(a1)+" "+trim(b1)

 

[Emmanuel]

Thanks,
What I need is : trim(a1)+trim(b1)+trim(c1) alltogether to
appear into , say , d1.

Then to avoid doing this for each row , need to do it for
a range of rows

I tried to use the consolidation command following helpers
instructions but I failed.

Thanks again for your help.

 

[Don Guillett]

so type it in in cell d1 and copy down with the copy handle in the lower
right corner of the cell.
=trim(a1)+trim(b1)+trim(c1)

 

[Dave Peterson]

I think I'd use the ampersand (&) character instead of the plus (+).

And maybe:
=trim(a1&" "&b1&" "&c1)

The =trim() function gets rid of leading and trailing spaces (and duplicated
internal spaces, too).

And the & operand puts strings together.

alternatively--but more typing:
=trim(concatenate(a1," ",b1," ",c1))

does the same.

 

[Guest]

Thanks a lot Dave,it worked

Too simple as I thought. I was getting in deeper water
than I needed to be.

Emmanuel