| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto fill of cell with information from seperate sheet | Excel Worksheet Functions | |||
| When merging information not merging correctly | Excel Worksheet Functions | |||
| Seperate Cell Information (lastname, firstname) | Excel Discussion (Misc queries) | |||
| Merging seperate workbooks into one workbook | Excel Discussion (Misc queries) | |||
| merging text information | Excel Discussion (Misc queries) | |||
Linear Mode
