Combine Cells in a column onto one cell

  • Thread starter Thread starter Emmanuel
  • Start date Start date
E

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
 
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.
 
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)
 
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.
 
Thanks a lot Dave,it worked

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

Emmanuel
 
Back
Top