apple
Apricot
Avocado
Apples
Banana
Blackberry
Cherry
Blueberry
Coconut
Cranberry
Date
Fig
Apple;Banana;Cherry;Cranberry;Fig
Each individual word must exactly match (not case sensitive) the value of the line of text.
The original text in a cell A1 consists of 26 lines, including blank ones. The result should match the following:
- Lines 1, 10, 13, 20 and 26 should be removed after match checking.
- Blank consecutive lines greater than 1 should be replaced with 1 blank line.
- Blank lines before and after a non-blank value should be removed.
Apricot
Avocado
Apples
Blackberry
Blueberry
Coconut
Date