Assume name and address is in Row1 and city/state/zip is in Row2, then:

B1 = =A1&" "&A2


Hope this helps...


"BobVanS" wrote:

I have an excel file that was created from some report writer and I have name
and address in one row, and city/state/zip in a second row. How can I append
the second row to the first? I can point to it with a formula, but really
want to move the actual value without doing a cut/paste for each row.