Remove Line Breaks ALT + ENTER

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?

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" <Highman@discussions.microsoft.com> wrote in message
news:0E317BFB-0D2C-4313-8149-DD283E2A7DAB@microsoft.com...
> 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?

Thanks for your speedy reply!

My problem is the line break itself. Using your excellent tool tranforms the
characters back into line breaks in Excel. But I would love to get rid of teh
line break alltogether.

What can I do?

Thanks in advance for your help!



"zackb" wrote:

> 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" <Highman@discussions.microsoft.com> wrote in message
> news:0E317BFB-0D2C-4313-8149-DD283E2A7DAB@microsoft.com...
> > 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?
>
>
>

try <edit><find and replace>
just enter alt enter in the find and space or whatever in the replace
(At least works for me in 2002 XL)

"Highman" wrote:

> Thanks for your speedy reply!
>
> My problem is the line break itself. Using your excellent tool tranforms the
> characters back into line breaks in Excel. But I would love to get rid of teh
> line break alltogether.
>
> What can I do?
>
> Thanks in advance for your help!
>
>
>
> "zackb" wrote:
>
> > 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" <Highman@discussions.microsoft.com> wrote in message
> > news:0E317BFB-0D2C-4313-8149-DD283E2A7DAB@microsoft.com...
> > > 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?
> >
> >
> >

Highman

After import you could try Edit>Replace

what: ALT + 0010(or 0013).....use the numpad to enter the 0010

with: nothing

Replace all.


Gord Dibben Excel MVP


On Tue, 26 Apr 2005 12:37:05 -0700, "Highman"
<Highman@discussions.microsoft.com> wrote:

>Thanks for your speedy reply!
>
>My problem is the line break itself. Using your excellent tool tranforms the
>characters back into line breaks in Excel. But I would love to get rid of teh
>line break alltogether.
>
>What can I do?
>
>Thanks in advance for your help!
>
>
>
>"zackb" wrote:
>
>> 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" <Highman@discussions.microsoft.com> wrote in message
>> news:0E317BFB-0D2C-4313-8149-DD283E2A7DAB@microsoft.com...
>> > 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?
>>
>>
>>