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 |
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 |
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 |
All times are GMT +1. The time now is 02:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com