gary c wrote:

How can I move the cell containing "paid status" and the cell
containing the first "70-nnnn" up to the same row as the preceding
cell containing "ASSESSMENT NO"?

Here's my spreadsheet:
[snip]
===============================================

Here's the result I'm looking for:
[snip again]

Your data got mangled by wordwrap. Put your data on pastebin.com (or a
similar site) and then post the resulting link here.

--
Usenet is Eeyore's birthday present.