Word/Excel Question

[F1rstT1meMummy]

Hi
I am doing my dissertation and have transcribed lots of interviews into word.
I would now like this info to sit within a table of some kind, this can be either excel or word.

What i would like is one row for each paragraph, so that I can insert a column to the left to code the information.

Does anyone know how to do this please?

I dont want to sit and copy/paste 55 pages of transcript, para by para into a table!

(note to self, a) always set up a table first, b) dont ever do any more postgraduate study, and c) dont leave anything, if you do insanely decide to do more, until the last minute)

Thanks in advance

Depends on the version, I have 2010 but should be the same in 2007 and similar in other versions.

Select all the text you want to convert. Click on Insert -> Table -> Convert Text to Table; make sure 'Separate text at' is set to 'Paragraphs' and click OK.

This will give you a one column table, you can now right click in the table (with the whole table still selected) and choose 'Insert columns to the left'. Alternatively, copy and paste the table into Excel.

Thank you very much!! It worked