+ Reply to Thread
Results 1 to 3 of 3

transform data separated with comma into 1 column

  1. #1
    Registered User
    Join Date
    07-02-2014
    Location
    Prague
    MS-Off Ver
    2007
    Posts
    59

    transform data separated with comma into 1 column

    Hi guys,

    I would like to ask the more experienced ones how to deal with the following problem:

    In B1, I have several text strings separated by comma and blank space
    Please Login or Register  to view this content.
    I would like to transform this text into the column A so there will be one word at a line
    Please Login or Register  to view this content.
    The original file contains about 500 word in B1 so if there is an elegant way how to achieve that, it would save me a lot of time.

    Thank you, any help will be appreciated.
    samplefile.xlsx

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: transform data separated with comma into 1 column

    in B1 use text to columns => Data => text to column => use komma as seperator

    After that copy => paste special => transpose.

    See the attached file for the result.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: transform data separated with comma into 1 column

    Try this one too...

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Evaluating rows column-by-column to separate comma-separated data
    By adventurepirate in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2014, 03:06 PM
  2. Replies: 1
    Last Post: 05-29-2014, 12:27 PM
  3. [SOLVED] separate cell with comma separated data into one column
    By Tenos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-12-2012, 02:45 PM
  4. Replies: 1
    Last Post: 09-07-2006, 11:17 PM
  5. Replies: 1
    Last Post: 09-07-2006, 04:28 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1