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,
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?
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks