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!

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!

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!

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