Thread: how do i combine the contents in a colum to the conten next to it
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ms-Exl-Learner Ms-Exl-Learner is offline
external usenet poster
  
Posts: 506
Default how do i combine the contents in a colum to the conten next to it
Method 1
=A1&B1&C1
If you want to add some more cells then add & symbol and mention the cell
name.

Method 2
=CONCATENATE(A1,B1,C1)

If you want to give space between the cell values then construct your
formula like this.

=CONCATENATE(A1," ",B1," ",C1)
=A1&" "&B1&" "&C1

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"gin" wrote:

im trying to merge an entire column into the column next to it. and keep the
same rows
Reply With QuoteReply With Quote