-2
I have a data in Column A1 some data and I want to combine data from Column B1, D1 and E1 to Coumn A1, how do I do it using macro in excel 2003.
Thilaga
Posted 2012-09-06T10:41:18.773
Reputation: 1
How to merge data B and C cell into A cell and applie the same to all rows
Answers
0
You can use use CONCATENATE()
See this screen shot:
Further details on the Microsoft Office website.
I use this a lot and it's very powerful as it's not limited to text between each comma, you can put in other functions, such as this silly example (you can apply this to the screenshot above, pasting the code into cell C1):
=CONCATENATE(IF(HOUR(NOW()) < 12, CONCATENATE("Morning and ", A1, " to"), A1), " ", B1)
Dave
Posted 2012-09-06T10:41:18.773
Reputation: 24 199
Your answer is correct, and the way I would do it, but the question asks for the results to be in A1 along with the data which already exists there. You may want to add inserting a column at A in order to completely answer the question. – CharlieRB – 2012-09-06T11:38:44.383
@CharlieRB, thank you for pointing this out. However, I don't think it's possible. If you know a way, please feel free to answer separately. – Dave – 2012-09-06T11:45:40.053
I don't think it's possible unless you enter the value of A1 into the concatenation - this would fail if the formula had to be copied due to the hard coding. – Dave – 2012-09-06T11:57:27.507
Agreed. The user is going to have to insert a column in order to achieve what they desire of having it in the first column. – CharlieRB – 2012-09-06T12:25:46.960
Are you sure you want a macro to do this? As Dave Rook has shown below, it can be accomplished using a
CONCATENATEformula. – CharlieRB – 2012-09-06T11:40:04.740