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
|