Excel 2003 stripping out line feeds

P

PJ

I have a tab delimited text file that I am opening with Excel. The text file
has embeded linefeeds/chr(10) in the following format

char(34) & text & chr(10) & text & chr(34) & chr(9) & char(34) & text &
chr(10) & text & chr(34)

This should allow multiple lines of text into a single cell with cells
delimted by tabs. This worked in excel 2003 until we updated office with the
latest service pack and patches. Now, Excel strips out the linefeed
character and places the text into a new row.

This behavior can alo be duplicated in Excel. Open a new workbook. Click
into a cell and type some text. Enter Alt-enter and enter more text. Save
AS a text file. Open in Notepad and you will see the Quotes and chr(10).
Reopen in excel and it has stripped out the linefeeds again

Does anyone know how I can resolve this?
 
P

PJ

Thanks for the response. I reviewed the article and then checked the
version of Excel. I had the lastest patch version (11.0.8211.0 ) that is
SUPPOSED to fix it. I uninstalled the patch and everything works as it
should. Looks like MS needs a version 3.

thanks again
 
J

Joel

Create a new posting and use the "Suggestion for Microsoft" option. Let them
know there are still problems.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top