+ Reply to Thread
Results 1 to 5 of 5

Split multi-line data into multiple columns

  1. 05-15-2019, 09:34 PM #1
    tax112
    tax112 is offline
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    438

    Split multi-line data into multiple columns

    Hi everybody
    Can someone help me extract data like in File
    Thank you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-15-2019, 10:04 PM #2
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Split multi-line data into multiple columns

    If you don't understand, just ignore like your previous thread.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 05-15-2019, 10:10 PM #3
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Split multi-line data into multiple columns

    Hi tax112,

    No VBA needed if you put this formula in I2 and pull it across and down. See the attached:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Indirect SPLIT DATA ROWS TO COLUMNS (1).xls

    After you do the formula, I'd copy the answer and paste over it using values only...
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  4. 05-16-2019, 01:27 AM #4
    tax112
    tax112 is offline
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    438

    Re: Split multi-line data into multiple columns

    Thank Jindon
    Thank you very much.
    Reply With QuoteRegister To Reply
  5. 05-16-2019, 01:29 AM #5
    tax112
    tax112 is offline
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2016 | 2019
    Posts
    438

    Re: Split multi-line data into multiple columns

    Thank MarvinP.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multi-Line Excel Address Fields - How to split and move to other columns
    By mjwillyone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-17-2017, 02:54 PM
  2. [SOLVED] Split data into multiple columns
    By rg2014 in forum Excel General
    Replies: 8
    Last Post: 11-05-2014, 10:07 PM
  3. Split uneven data from a single columns to multiple columns
    By pfoz in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-13-2013, 08:24 AM
  4. Extracting data from multiple columns with multi value matching
    By Antagonizer82 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-31-2012, 02:59 PM
  5. split multi-tab spreadsheet into multiple spreasheets.
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2009, 02:55 PM
  6. Split text like line wrap into multi columns
    By 1scant in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2006, 03:53 PM
  7. how can I paste multi-line/multi-paragraph data into ONE cell?
    By Theano in forum Excel General
    Replies: 3
    Last Post: 06-07-2005, 09:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1