Combining colums in Excel
Hi,
I'd like to know how to take the text from cells in column B and "append" it
to the text contained in column A. For example, here's what I have:
Col A Col B
good bad
boy girl
uncle aunt
I'd like to modified Col A as below:
Col A
goodbad
boygirl
uncleaunt
How can I do this? I tried to do this by writing the code below but that
doesn't work since it's recursive.
Worksheets("Temp3").Cells(startrow1, 4).Value =
Worksheets("Temp3").Cells(startrow1, 4).Value & _
Worksheets("Temp3").Cells(startrow1, 4).Value & ","
Thanks for help.
|