Merge data from two columns in to one.

[manharji]

I have data in column A and B. I would like to merge column A and B in Result column C.

Example:
(Data-1) cell A2 = Rows("1:1").RowHeight =
(Data-2) cell B2 = 2.25
(Result) cell C2 = Rows("1:1").RowHeight = 2.25
What is the formula for cell C2 ?
Please see attached sheet.
Thanks.

[Osvaldo Palmeiro]

C2= A2&B2
Then double click at the bottom right corner of cell 'C2' to copy down.
If you wish values instead of formulae then copy the range and replace it with paste special >> values