Every column is marked with a code (<1>begins every cell in the first column, <2> begins every cell in the second column, etc.). I will save my Excel file to text and bring it into a desktop publishing program and use the codes to arrange the information differently.
When I'm done, each row will be a separate paragraph. I will format my pages with 2 paragraphs per page. It would be easier (there are 2600 rows in this database) if I could tag every other row with a different code. IOW, <1a> for cell A1, <1b> for cell A2, <1a> for cell A3, <1b> for cell A4, etc.
Right now I'm using Find/Replace and replacing every other <1> code with a <1a> code, but this is very slow. Is there an easy way to do this? Ideally, I'd like to be able to mark every other row within a selected range, not the entire spreadsheet. I'm using Excel 2000.
Ken Benson
Bookmarks