| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
display values in cell
Hi,
how can i display values in 2 cells into a 3rd cell? eg. cell 1 value is US cell 2 value is 1234 cell 3 to display US1234 [both cell 1 & 2 value] regards |
|
#2
|
|||
|
|||
|
Assuming A1=US and B1=1234, in cell C1 put
=A1&B1 to get US1234 Vaya con Dios, Chuck, CABGx3 "Vincent" wrote in message ... Hi, how can i display values in 2 cells into a 3rd cell? eg. cell 1 value is US cell 2 value is 1234 cell 3 to display US1234 [both cell 1 & 2 value] regards |
|
#3
|
|||
|
|||
|
one way:
A1: US A2: 1234 A3: =A1 & A2 In article , "Vincent" wrote: Hi, how can i display values in 2 cells into a 3rd cell? eg. cell 1 value is US cell 2 value is 1234 cell 3 to display US1234 [both cell 1 & 2 value] regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
| display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
| How to display cell values in wordarts? | Excel Discussion (Misc queries) | |||
| Display actual contents of cell | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
