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?

Look at this posting from this morning. There is another patch required.

http://www.microsoft.com/office/comm...a-af0577eb7f94

"PJ" wrote:

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?

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

"Joel" wrote:

Look at this posting from this morning. There is another patch required.

http://www.microsoft.com/office/comm...a-af0577eb7f94

"PJ" wrote:

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?

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

"PJ" wrote:

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

"Joel" wrote:

Look at this posting from this morning. There is another patch required.

http://www.microsoft.com/office/comm...a-af0577eb7f94

"PJ" wrote:

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?