Hi there,

ASAP Utilities has a function to do this. http://www.asap-utilities.com

For the Excel user who really gets a lot of use out of Excel, this is a
great add-in to have.


HTH, and regards,
Zack Barresse


"Highman" wrote in message
...
Hi,

I' have a sheet with thousands of extra line breaks. In order to import
thsi
sheet I would love to remove all these line breaks automatically. How do I
do
this?