copy 2 cells into 1 cell
 

i have 2 cells,

---Time----Day----
--640------Mon---

how do i copy the 2 different data from 2 different cells into 1
cell,example as below,

---Remarks--
--Mon 640---


--
new_to_vba
------------------------------------------------------------------------
new_to_vba's Profile: http://www.excelforum.com/member.php...o&userid=30131
View this thread: http://www.excelforum.com/showthread...hreadid=516065

copy 2 cells into 1 cell
 

Hi New_to_VBA,

Manually:

A1: 640
B1 Mon
C1: =B1 & " " & A1 == Mon 640

With VBA:

Range("C1").Value = Range("B1").Value _
& " " & Range("A1").Value


---
Regards,
Norman



"new_to_vba" wrote
in message ...

i have 2 cells,

---Time----Day----
--640------Mon---

how do i copy the 2 different data from 2 different cells into 1
cell,example as below,

---Remarks--
--Mon 640---


--
new_to_vba
------------------------------------------------------------------------
new_to_vba's Profile:
http://www.excelforum.com/member.php...o&userid=30131
View this thread: http://www.excelforum.com/showthread...hreadid=516065

copy 2 cells into 1 cell
 

Range("C2").Value = Range("B2").Text & " " & Range("A2").Text

--
Regards,
Tom Ogilvy


"new_to_vba" wrote
in message ...

i have 2 cells,

---Time----Day----
--640------Mon---

how do i copy the 2 different data from 2 different cells into 1
cell,example as below,

---Remarks--
--Mon 640---


--
new_to_vba
------------------------------------------------------------------------
new_to_vba's Profile:
http://www.excelforum.com/member.php...o&userid=30131
View this thread: http://www.excelforum.com/showthread...hreadid=516065