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.
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):