Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Cells
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Cells
Do you just want them to display together, and update when A1 and B1 are
updated? C1: =A1 & B1 or C1: =A1 & " " & B1 To paste them, select A1 & B1, select C1, click in the formula bar or double-click in the cell (depending on your option settings) and paste. That will insert a space between the A1 and B1 values. In article , xenter wrote: I am using Excel 2003. Is there any way to take two different cells and paste them into 1 cell. Ex:Column A Row 1(QA36) Column B Row 1 (.B67) and put them both in Column C Row 1. Thank You Terri Smith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
Can I connect Excel cells to cells in an embedded Word table? | Excel Discussion (Misc queries) | |||
transfer data into row cells from column cells in Excel | Excel Discussion (Misc queries) | |||
conditional formating cells i Excel based on other cells values | Excel Worksheet Functions | |||
Pasting single cells from Word to multiple cells in Excel | Excel Worksheet Functions |