I am copying a transcription of an interview from Word to Excel.
In the Word doc all lines are numbers and I need to keep this feature.
When I paste into Excel, a paragraph (with say 5 lines in Word) merges into one cell, therefore there is a disparity between the number of lines in Word vs Excel. I need to keep the 5 lines from word to be 5 lines in excel.
Any suggestions would be great.
Thanks
In the Word doc all lines are numbers and I need to keep this feature.
When I paste into Excel, a paragraph (with say 5 lines in Word) merges into one cell, therefore there is a disparity between the number of lines in Word vs Excel. I need to keep the 5 lines from word to be 5 lines in excel.
Any suggestions would be great.
Thanks