Hi,

Why do you have two rows? I recommend concatenating the two into one row
only - insert a new row and in A1:

=A2&" "&A3

Copy this formula throughout the length. You can still wrap the text within
the cell. You can then copy row 1 and paste over it again as values (Edit -
Paste Special).

Delete rows 2&3 and re-sort.

Regards,
A

"Pam Coleman" wrote:

I have a spreadsheet with Row 1 and Row 2 as headers. When I sort, it sorts
the 2nd row header with my information. Is there a way to keep row 2 from
sorting with my infor?