How does excel note a newline (ie new line but in same cell)

[sylsoft]

Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hi
Have legal transcription i need to manipulate partly in excel on mac. want each cell to be one question or answer in deposition, but can't allow excel to wrap the text of the question or answer, which is typically several lines, as in depositions each line is numbered and i want to preserve the numbers matching the lines. so i would like to manually add the character/formatting in my text editor before i bring the text back into excel.

or perhaps i can write an excel macro or formula to combine the cells into one cell, but keeping the line ends the same by manually (as in the macro manually) wrapping the lines?

any help appreciated. i see in windows the 'newline' is a line feed (ascii character 10) but inserting this and bringing the text into mac excel puts the text into 2 cells
thx
rich

 

[John McGhie]

Command + Option + Return will give you a hard line-end in a cell.

However, you will probably find that this prevents Excel from doing what you
want. One of the keys to getting Excel to work properly is to have only one
data item in each cell.

Are you sure you can't do what you want in a Word table? You can then
automatically number the rows so you get your line numbers.

Cheers

Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hi
Have legal transcription i need to manipulate partly in excel on mac. want
each cell to be one question or answer in deposition, but can't allow excel to
wrap the text of the question or answer, which is typically several lines, as
in depositions each line is numbered and i want to preserve the numbers
matching the lines. so i would like to manually add the character/formatting
in my text editor before i bring the text back into excel.

or perhaps i can write an excel macro or formula to combine the cells into one
cell, but keeping the line ends the same by manually (as in the macro
manually) wrapping the lines?

any help appreciated. i see in windows the 'newline' is a line feed (ascii
character 10) but inserting this and bringing the text into mac excel puts the
text into 2 cells
thx
rich

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[sylsoft]

Thanks for tip on the hot key, but doesn't apply. Ultimately I'm massaging data that is to go into another program. So i need to know how excel indicates in the file that there is a newline (defined as start new line in same cell). I can cut and paste into a text editor, manipulate and cut and paste back into excel and somehow excel seems to know.

Upon more thought and testing, though, the newline won't make it from excel into the text export that i'd need to to be able to load into the final program, so I'll have to do it with XML.

Thanks anyway.

 

[John McGhie]

It should make it out to ANSI text as 0D0A...

Thanks for tip on the hot key, but doesn't apply. Ultimately I'm massaging
data that is to go into another program. So i need to know how excel indicates
in the file that there is a newline (defined as start new line in same cell).
I can cut and paste into a text editor, manipulate and cut and paste back into
excel and somehow excel seems to know.

Upon more thought and testing, though, the newline won't make it from excel
into the text export that i'd need to to be able to load into the final
program, so I'll have to do it with XML.

Thanks anyway.

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]