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?
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?