excel help please!!!!!

[Teric506]

Hello,

I have exported a document to excel and one of my rows have descriptions in
it. When I exported it over it brought over all these return marks and when
you click on one cell, it has part of the decription than four blank lines
and then more of the description. Is there an easy way to get rid of all
those blank lines within the cell. I put an example of this below this is
everything that is inside of one cell - you see there is the first part, than
blank lines and then another part. Any help would be great.
Teri


MISC, HEAT SHRINK TUBING, 1/2 EXP x 1/4" ALPHA FIT-221-1/4-4B






058-005-064

[Phillycheese5]

While there are functions in Excel to remove blank rows and combine data, I think the best approach is to make an adjustment to the source data. I have found that sometimes for relatively small datasets, copying and pasting the data in a program like Notepad as a txt file, then opening it into Excel does the trick.

[pdberger]

If the problem is the same in each cell, then you should be able to use the
Replace function. Select the cells, then >Edit>Replace (Ctrl-H). Type in
the code sequence you want to replace (which might be ^p^p^p^p) and then
leave blank the field showing what you want to replace it with. Replace in
one or two cells so you know it's doing what you want it to.

HTH

"Teric506" wrote:

> Hello,
>
> I have exported a document to excel and one of my rows have descriptions in
> it. When I exported it over it brought over all these return marks and when
> you click on one cell, it has part of the decription than four blank lines
> and then more of the description. Is there an easy way to get rid of all
> those blank lines within the cell. I put an example of this below this is
> everything that is inside of one cell - you see there is the first part, than
> blank lines and then another part. Any help would be great.
> Teri
>
>
> MISC, HEAT SHRINK TUBING, 1/2 EXP x 1/4" ALPHA FIT-221-1/4-4B
>
>
>
>
>
>
> 058-005-064

[Duke Carey]

Use the CLEAN() function. If the problem text is in column B, insert a new
column C and use

=CLEAN(B1)

and copy it down. Then Edit->Copy all the new cells, and use Edit->Paste
Special->Values to convert them to constants


"Teric506" wrote:

> Hello,
>
> I have exported a document to excel and one of my rows have descriptions in
> it. When I exported it over it brought over all these return marks and when
> you click on one cell, it has part of the decription than four blank lines
> and then more of the description. Is there an easy way to get rid of all
> those blank lines within the cell. I put an example of this below this is
> everything that is inside of one cell - you see there is the first part, than
> blank lines and then another part. Any help would be great.
> Teri
>
>
> MISC, HEAT SHRINK TUBING, 1/2 EXP x 1/4" ALPHA FIT-221-1/4-4B
>
>
>
>
>
>
> 058-005-064