Need Excel Macro to combine 3 cells into one cell

[srirangam.kalyan]

Hi,

I have a requirement to bulid a macro, where I need to merge 2-3 columns data into one cell.

For example

Sheet 1

ID Report Summary
---- -------- ---------
101 ABC Description of ABC
102 EFG Description of EFG

I need a macro to combain ID +Report + Summary into one cell and it should continue for rest of the rows.
I need it in below format
-------------------------
101 ABC
Description of ABC
-------------------------
102 EFG
Description of EFG
------------------------
Regards
Kalyan

[stnkynts]

Here ya go. I assumed columns A,B,and C respectively with the result in column D

Please Login or Register  to view this content.

[srirangam.kalyan]

Thanks a lot Stnkynts for quick reply. It works perfectly....

[srirangam.kalyan]

One more, If I want to show in diferent color for each data coming from different cells, how to do it?