How could I import text into Microsoft Excel so that every word would be in its own cell?

Question

I'm doing a linguistic comparison of two texts and want to see which of the two has the bigger vocabulary. There might be a linguistic program for this, but right now, I'm simply wondering if I could process the two texts so that every word is listed alphabetically, and simply counting from there. Getting the text into excel and ordering the cells from there would be a good start.

Note: I know how to paste text into Excel! It's getting every word into its own cell that's causing me problems.

Answer 1

You didn't mention HOW you were going to import the text, but the easiest way is to use a .TXT file. When you import a TXT file, you can have each string of text that is separated by a tab, semi-colon, comma, space, and one other character of your choice to be placed into a separate cells.



To assist you in doing those counts, take a look at this free download to do word frequency counting:



http://spreadsheetpage.com/index.php/file/generate_a_word_frequency_list/



NOTE: If you use that macro, the text must be in ONE column to be counted.

Answer 2

You could use the Text to columns facility using a space as the delimiter, There might be a few words in the text that need to be manually extracted, It would then be upto COUNTIF formula to do the comparison work.

Answer 3

hmmmmm. idk bout that 1. i would say just type each 1 individually.