Merging Information From Two Seperate Cells
 

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"?


--
Thanks,

Bdigs

Merging Information From Two Seperate Cells
 

Look at the CONCATENATE function, or the & operator.
--
David Biddulph

"bdigs" wrote in message
...
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"?


--
Thanks,

Bdigs

Merging Information From Two Seperate Cells
 

Try

=A1&B1

or
=A1&" "&B1

Mike

"bdigs" wrote:

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"?


--
Thanks,

Bdigs

Merging Information From Two Seperate Cells
 

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" wrote:

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"?


--
Thanks,

Bdigs

Merging Information From Two Seperate Cells
 

Fantastic! It worked perfectly. Thanks for your time.
--
Thanks,

Bdigs


"Mike H" wrote:

Try

=A1&B1

or
=A1&" "&B1

Mike

"bdigs" wrote:

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"?


--
Thanks,

Bdigs

Merging Information From Two Seperate Cells
 

That did it. Thanks for your time.
--
Thanks,

Bdigs


"Vinod" wrote:

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" wrote:

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"?


--
Thanks,

Bdigs

Merging Information From Two Seperate Cells
 

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


Gord Dibben MS Excel MVP

On Thu, 18 Sep 2008 11:15:01 -0700, bdigs
wrote:

Fantastic! It worked perfectly. Thanks for your time.