Copying Text from cell to add to text in another cell

  • Thread starter Thread starter hyyfte
  • Start date Start date
H

hyyfte

Here's what I want to do:
Cell A1 = "TextA"
Cell B1 = "TextB"

I want to take the text from Cell A1 and add it to the text in Cell B
so cell B1 reads: "TextB TextA". Is this possible? My problem is tha
I can copy cell A1, but when I paste to B1, it pastes over the text i
B1. If I do it by hand, I would hit F2 to edit the contents of th
cell and just paste the text. I need a macro to do this. Please help
 
hi,
in cell c1 you might enter
=CONCATENATE(A1,B1)
if you wish a space beteen the text then enter this
=CONCATENATE(A1,& " " &,B1)
 
Back
Top