Convert words in a paragraph into a single column of words

[justabc]

Is there anyway to paste a paragraph into excel and then somehow change the paragraph to a single column composed of the words from that paragraph?

 

[Zack Barresse]

i don't understand. you want the words horizontal, but one word only per line? or all words vertical?

 

[MartinK]

Re: Convert words in a paragraph into a single column of wor

I'd say, Text To Columns, space as delimiter, then copy, paste special (transpose checked).
Works only for 256 words though.
Martin

 

[justabc]

Re: Convert words in a paragraph into a single column of wor

All words that are in this paragraph to end up as below

All
words
that
are
in
this
paragraph
to
end
up
as
below


1 word in each cell of a column


Thanks

 

[Zack Barresse]

go with Martin's solution.

 

[justabc]

Re: Convert words in a paragraph into a single column of wor

Thanks for help

 

[justabc]

Re: Convert words in a paragraph into a single column of wor

Is there any work around the limit of 256 words?

If not, and my paragraph is say 1000 words, is there any way to paste in the 1000 words and then first parcel the 1000 word paragraph into 256 word new "paragraphs" and once this is done, to then proceed with my column operation for each new "paragraph"?

Thanks