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 |