Solved: Concatenation of columns

[jumbel]

I have three columns with data and I need to concatenate the three columns and display it in the fourth column.

I need to write a macro for this and I dont know how many rows of data exist. The number of rows may change anytime. Is there any specific code to do this.....Bugging me since one hour.:dunno

[Bob Phillips]

Why not just a formula

=A2&B2&C2

[jumbel]

Yes, I can but how can I do that for all rows at the same time.

[Bob Phillips]

Select all cells, D2 down, enter the formula in the formula bar, and hit Ctrl-Enter. Voila.

[jumbel]

Thanks man, CTRL-Enter was the key here....so simple

[Bob Phillips]

A useful, not so well known, key combination :-)