Happy new year. I think in Column C that you need a formula to merge the
first and last names from Columns A and B. Assuming your names start in Row
2 (the first row is usually reserved for Column headings), try this: In Cell
C2 type -
A2&" "&B2. The quotes will give you a space between the first and last
name. HTH
--
Sincerely, Michael Colvin


"excel moron" wrote:

I am trying to merge two row's into one row. I can merge two cells into one
but when i go to auto fill the row it fill's it with the result of the first
merge. for example: ROW A First Name ROW B Last Name ROW C first name last
name
John DOE
John DOE
Jane DOE
John DOE
I have used paste special value and still get the same result