Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel help please!!!!!
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 |
#2
|
|||
|
|||
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. -- Phillycheese5 ------------------------------------------------------------------------ Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196 View this thread: http://www.excelforum.com/showthread...hreadid=474261 |
#3
|
|||
|
|||
If the problem is the same in each cell, then you should be able to use the
Replace function. Select the cells, then EditReplace (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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |