How to select rows either beginning with a 'BOLD' word or a capital E?

I've tried to make that as descriptive as I can! I've inherited a long, long list of contacts from the previous PA in this job - we're talking well over 5000 rows.

The format of the rows is generally:

Row 1: Smith, John (the surname is always bold)
Row 2: First line of address
Row 3: Country
Row 4: T 01595555555
Row 5: E [email protected]

My boss has asked me to go through removing the addresses and telephone numbers so I can import into his Outlook - I thought about running a Macro that would remove every 'Row 2-4' but the problem is there isn't always a 'third row', so it doesn't work effectively.

What I'm really looking for is a macro or filter that would show only rows that either start with a 'bold' word or the capital E - but I'll run into trouble with the E thing when it comes to surnames beginning with E.

I know this is probably easy and I'm being especially dense at not being able to figure it out - if anyone could help, I'd be most obliged!

Many thanks
J

Perhaps:

Please Login or Register  to view this content.

Oh now that is good! Absolutely spot on - worked a treat.

Thank you very much