Convert words in a paragraph into a single column of words

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Convert words in a paragraph into a single column of words

  1. #1
    Board Regular
    Join Date
    Dec 2002
    Posts
    86
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Convert words in a paragraph into a single column of words

     
    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?

  2. #2
    MrExcel MVP Zack Barresse's Avatar
    Join Date
    Dec 2003
    Location
    Oregon, USA
    Posts
    10,693
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i don't understand. you want the words horizontal, but one word only per line? or all words vertical?
    Regards,
    Zack Barresse
    My Book on Excel Tables
    My Blog @ ExcelTables.com
    (If you would like comments in any code, please say so.)

  3. #3
    Board Regular MartinK's Avatar
    Join Date
    Oct 2003
    Location
    Prague, CZ / Zagreb, HR
    Posts
    384
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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

  4. #4
    Board Regular
    Join Date
    Dec 2002
    Posts
    86
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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

  5. #5
    MrExcel MVP Zack Barresse's Avatar
    Join Date
    Dec 2003
    Location
    Oregon, USA
    Posts
    10,693
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    go with Martin's solution.
    Regards,
    Zack Barresse
    My Book on Excel Tables
    My Blog @ ExcelTables.com
    (If you would like comments in any code, please say so.)

  6. #6
    Board Regular
    Join Date
    Dec 2002
    Posts
    86
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    Thanks for help

  7. #7
    Board Regular
    Join Date
    Dec 2002
    Posts
    86
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com