| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine the contents of 2 cells
I would like to combine the contents of 2 cells. In Cell A1 is a name in
cell A2 is a number. I would like the result to look like the example below. Brian Smith represents the value in Cell A1 and 1134 represents the value in Cell A2 Brian Smith - 1134 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine the contents of 2 cells
Try this:
=A1&" - "&A2 -- Biff Microsoft Excel MVP "Patrick C. Simonds" wrote in message ... I would like to combine the contents of 2 cells. In Cell A1 is a name in cell A2 is a number. I would like the result to look like the example below. Brian Smith represents the value in Cell A1 and 1134 represents the value in Cell A2 Brian Smith - 1134 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I combine the contents of two columns? | Excel Worksheet Functions | |||
| How can I combine cell contents? | Excel Discussion (Misc queries) | |||
| I am trying to combine contents from 2 cells into 1 | Excel Worksheet Functions | |||
| How do I combine the contents of multiple cells in one cell? | Excel Worksheet Functions | |||
| Combine the contents of two cells. | New Users to Excel | |||
Linear Mode
