Pasting words from paragraphs into separate cells

[Cleland]

Hi there,

I was wondering if anyone had any advice or knew any clever ways to paste text into a spreadsheet in a way whereby each word went into a separate cell in column A.

Basically, what I'm trying to do is to take a chapter of a book and count the number of times each word appears. I was hoping to create a word cloud type thing.

I think the work will probably be in preparing the text. I was wondering if anyone knew of a character or symbol that excel might recognise as an indicator to move to the next row and paste the next word? Then I could just replace all the spaces with that character in notepad and paste it in.

I've never used Macros, but I'm wondering if there is anything in that that could be of use? If anyone has any thought they be much appreciated. Entirely possible that there is a much simpler way to do what I'm trying to do, so if you think so please say!

Thanks very much!

Tom

[teylyn]

Hello,

paste the paragraph into a cell in column A. Then select the cell and perform a Text to Columns > Delimited > space character as the delimiter. Copy the result, select the next empty cell in column A and use Paste Special > transpose.

cheers,