Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unicode text and carriage returns
If I enter carriage returns in a cell (Alt + Enter), then save the
sheet from Excel as "Unicode Text" file type, then open the file, the carriage returns are interpreted as delimiters. In the Text Import Wizard, I've made sure that the only delimter is Tab, which is the default when opening that file. If I look at the file in Notepad, the Alt + Enter characters do not look like tabs at all. I have other tabs in the file and they look like tabs, but the Alt + Enter characters look different. In Step 1 of Excel's Text Import Wizard, I've tried all the variations I can think off -- UTF-7, UTF-8, 1252, US-ASCII. In Step 2 of the Wizard, the text qualifier is """ (double-quote, the default), and in Notepad I see that the whole cell contents, including Alt+Enter carriage returns, are enclosed in doublequotes. Any ideas? How can I save carriage returns in cells, save the sheet as Unicode text, and import the text file without the carriage returns being interpreted as delimiters? Thanks, Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Text with Carriage Returns inside cell values | Excel Discussion (Misc queries) | |||
Can I insert 'carriage/line returns' in text string? | Excel Worksheet Functions | |||
How can I enter carriage returns into text within a cell in excel | Excel Discussion (Misc queries) | |||
Carriage returns | Excel Discussion (Misc queries) | |||
How do I get carriage returns to not be row delimiters in text fi. | Excel Discussion (Misc queries) |