Reply to thread

Message: [QUOTE="Laroche J, post: 6812105"] I think the simplest way to do it is with the AutoFilter, which you can activate from the Data / Filter menu. Small double arrows will appear in each cell of the first row. In your first column, type a character (any will do) in the cell on the left of the keywords you wish to export. Then click on the double arrow in the first cell of the first column and select from the little menu either the character you entered or (Show NonBlanks). All you have to do now is select all visible entries from the second column, copy, switch to your text file and paste. To select a long range of contiguous cells you can click on the first cell and press Shift-Ctrl-DownArrow. To change your keywords selection, select (Show All) from the AutoFilter list. JL Mac OS X 10.4.11 Office v.X 10.1.9, Office 2008 12.1.latest [/QUOTE]