When you merge cells, only the values in the left most cells are retained.

Better to use concatenation: =CONCATENATE(A1,B1,C1,D1,E1,F1) etc.

Dave
--
Brevity is the soul of wit.


"rhwong via OfficeKB.com" wrote:

I have numerous worksheets in the workbook that I want to merge. I only want
to merge columns A thru F in each worksheet. They have the same headings. Is
there a macro that I can run to merge them?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1