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