Results 1 to 7 of 7

Convert words in a paragraph into a single column of words

This is a discussion on Convert words in a paragraph into a single column of words within the Excel Questions forums, part of the Question Forums category; Is there anyway to paste a paragraph into excel and then somehow change the paragraph to a single column composed ...

  1. #1
    Board Regular
    Join Date
    Dec 2002
    Posts
    86

    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,494

    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
    ExcelTables.com
    All Excel Functions
    (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

    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

    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,494

    Default

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

  6. #6
    Board Regular
    Join Date
    Dec 2002
    Posts
    86

    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

    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

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