+ Reply to Thread
Results 1 to 3 of 3

How to spilt data in multiple cells that is in a cell that is wrapped no spaces

  1. 05-15-2014, 10:57 AM #1
    mjs591
    mjs591 is offline
    Registered User
    Join Date
    02-13-2012
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    2

    How to spilt data in multiple cells that is in a cell that is wrapped no spaces

    CURRENT VIEW DESIRED VIEW in 3 columns
    AA_BBB_CCCCC
    30_10_40_11111
    AB_CD_DE_FR" AA_BBB_CCCCC 30_10_40_11111 AB_CD_DE_FR
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-15-2014, 11:01 AM #2
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: How to spilt data in multiple cells that is in a cell that is wrapped no spaces

    Hi,

    In C2:

    =TRIM(MID(SUBSTITUTE($A2,CHAR(10),REPT(" ",999)),999*(COLUMNS($A:A)-1)+1,999))

    Copy across as required.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
  3. 05-15-2014, 12:37 PM #3
    ChemistB
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: How to spilt data in multiple cells that is in a cell that is wrapped no spaces

    You could also use "Text to Columns" putting ALT + 010 into "Other" delimiters
    (I believe must be done on a number keypad rather than the numbers at top of keyboard)
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    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. [SOLVED] Spilt of DATA
    By Nikunj15 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-10-2013, 05:15 AM
  2. [SOLVED] Split Wrapped Text (Multiple Lines) in A Cell to Multiple Columns
    By csmiin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-28-2012, 09:15 PM
  3. Cell data not visible (I have wrapped text & resized)
    By Toni D in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2006, 10:00 AM
  4. Autofit in cells with multiple lines of wrapped text.
    By John Keith in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-15-2006, 03:10 PM
  5. [SOLVED] RE: Autofit in cells with multiple lines of wrapped text.
    By John Keith in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-02-2006, 11:35 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