Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns with Line Breaks.
I have an Excel Spreadsheet that I inherited with approximately 2,500 rows.
One column has street address, city, state, zip, and phone. In between each piece of information was what appeared to be two line breaks. I used Alt+0010 to remove one of the line breaks. The second break will not disapper. I have also tried ctrl j. When I go to use Text to Column with a delimited file type, it does not recongize anything beyond the street address. What else can I try to remove the line break and the symbol of a "?" in a box? Any suggestions would be greatly appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns with Line Breaks.
CTRL + j and Alt + 0010 are the same thing.
Try Alt + 0013 Gord Dibben MS Excel MVP On Thu, 1 May 2008 12:23:00 -0700, eSite wrote: I have an Excel Spreadsheet that I inherited with approximately 2,500 rows. One column has street address, city, state, zip, and phone. In between each piece of information was what appeared to be two line breaks. I used Alt+0010 to remove one of the line breaks. The second break will not disapper. I have also tried ctrl j. When I go to use Text to Column with a delimited file type, it does not recongize anything beyond the street address. What else can I try to remove the line break and the symbol of a "?" in a box? Any suggestions would be greatly appreciated! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns with Line Breaks.
I tried that and it did not work. Any other ideas?
"Gord Dibben" wrote: CTRL + j and Alt + 0010 are the same thing. Try Alt + 0013 Gord Dibben MS Excel MVP On Thu, 1 May 2008 12:23:00 -0700, eSite wrote: I have an Excel Spreadsheet that I inherited with approximately 2,500 rows. One column has street address, city, state, zip, and phone. In between each piece of information was what appeared to be two line breaks. I used Alt+0010 to remove one of the line breaks. The second break will not disapper. I have also tried ctrl j. When I go to use Text to Column with a delimited file type, it does not recongize anything beyond the street address. What else can I try to remove the line break and the symbol of a "?" in a box? Any suggestions would be greatly appreciated! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns with Line Breaks.
Chip Pearson has a very nice addin that will help determine what that
character(s) is: http://www.cpearson.com/excel/CellView.htm Post back with your results. eSite wrote: I tried that and it did not work. Any other ideas? "Gord Dibben" wrote: CTRL + j and Alt + 0010 are the same thing. Try Alt + 0013 Gord Dibben MS Excel MVP On Thu, 1 May 2008 12:23:00 -0700, eSite wrote: I have an Excel Spreadsheet that I inherited with approximately 2,500 rows. One column has street address, city, state, zip, and phone. In between each piece of information was what appeared to be two line breaks. I used Alt+0010 to remove one of the line breaks. The second break will not disapper. I have also tried ctrl j. When I go to use Text to Column with a delimited file type, it does not recongize anything beyond the street address. What else can I try to remove the line break and the symbol of a "?" in a box? Any suggestions would be greatly appreciated! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text to Columns - Way to remove all column breaks at one time? | Excel Discussion (Misc queries) | |||
Inserting line breaks in text formula | Excel Discussion (Misc queries) | |||
remove line breaks in text strings | New Users to Excel | |||
Can you get line breaks in a text cell | Excel Discussion (Misc queries) | |||
Inserting line breaks into merged text cells. | Excel Discussion (Misc queries) |