I use excel and would like to know how to copy a large volume of address data but at the same time filtering out irrelevant data placed under each other in a row, in this case, air compressors air conditioning web address etc ( see below for example). I need the first 5 lines only. The rows of unwanted data are irregular i.e some have 10 lines, others 5 , and others 2 or one line which makes using a formula difficult as there is no consistency. The data eventually need to be placed horizontally in columns to be compared to other address lists. To make matters worse, the text data has been merged and wrapped. Help! This task is urgent and I don't have much time

BDD LIMITED
3 Telford Place
L*****r QLD 4315
Phone: 07 5777 3622
Fax: 07 5777 3622 Web: www.bDD.com.au
AIR COMPRESSORS:
AIR CONDITIONING - AUTOMOTIVE (PARTS-SERVICE-GAS):
CLOTHING:
PANEL SHOP & SPRAY EQUIPMENT: