Merging Information From Two Seperate Cells

[bdigs]

Hello All,

Is it possible in Excel to merge information from 2 seperate cells? For
instance one column containing "Names of Clients" and another column
containing "Client Addresses"?

 

[Mike H]

Try

=A1&B1

or
=A1&" "&B1

Mike

 

[Vinod]

Try itout;

Cell A1=Bush
Cell B1=California
Cell C1="=A1 & B1"
Type the above formulae in cell C1 without quotes. Is you required sapace
b/w name and address write like this =A1 & " " & B1 (here double quotes are
required. as many spaces you want you can give in-between quotes.

 

[bdigs]

Fantastic! It worked perfectly. Thanks for your time.

 

[bdigs]

That did it. Thanks for your time.

 

[Gord Dibben]

Having all that in one cell could make it very difficult to sort or filter.


Gord Dibben MS Excel MVP