+ Reply to Thread
Results 1 to 7 of 7

wrap text to separate columns

  1. 10-14-2023, 10:55 PM #1
    morrison2010_jim
    morrison2010_jim is offline
    Registered User
    Join Date
    10-14-2023
    Location
    Delaware
    MS-Off Ver
    2023
    Posts
    3

    wrap text to separate columns

    Please see the attached image. This is what I needed. I have wrap text and I want to separate it to different columns. Please see the attached image. Searched a lot, but couldn't find a solution. Can someone please help?
    Excel.JPG
    Reply With QuoteRegister To Reply
  2. 10-14-2023, 11:09 PM #2
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,501

    Re: wrap text to separate columns

    I don't know if your version of excel supports textsplit but if it does, this will work for you...
    =TEXTSPLIT(A2,CHAR(10))
    assumes that your current situation is in cell A2, repoint to the correct cell.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
  3. 10-15-2023, 11:48 AM #3
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,602

    Re: wrap text to separate columns

    In B2 and copied across.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
  4. 10-15-2023, 01:23 PM #4
    morrison2010_jim
    morrison2010_jim is offline
    Registered User
    Join Date
    10-14-2023
    Location
    Delaware
    MS-Off Ver
    2023
    Posts
    3

    Re: wrap text to separate columns

    Thank you Sam Capricci and kvsrinivasamurthy, your commands works perfectly for me.
    Reply With QuoteRegister To Reply
  5. 10-15-2023, 01:56 PM #5
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,924

    Re: wrap text to separate columns

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  6. 10-15-2023, 08:33 PM #6
    morrison2010_jim
    morrison2010_jim is offline
    Registered User
    Join Date
    10-14-2023
    Location
    Delaware
    MS-Off Ver
    2023
    Posts
    3

    Re: wrap text to separate columns

    Thank you for the information. I am new to this forum and this was my first post. I have done what you said. Please let me know if I am missing any steps.
    Reply With QuoteRegister To Reply
  7. 10-15-2023, 09:05 PM #7
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,501

    Re: wrap text to separate columns

    Glad I could help AND thank you for the rep!
    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. Is it possible to have Excel wrap text that overflows across multiple columns?
    By excel620 in forum Excel General
    Replies: 2
    Last Post: 07-05-2017, 12:58 PM
  2. [SOLVED] Wrap text on all columns from D and higher
    By davbran in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2014, 04:51 PM
  3. [SOLVED] Wrap Text in ListView: how to wrap text in the columns of a list view
    By TommyToe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 07:02 AM
  4. Text wrap and allow cell height to increase with wrap
    By tpenterprize in forum Excel General
    Replies: 1
    Last Post: 10-19-2007, 02:30 PM
  5. 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
  6. WRAP a text line over several columns without merging cells
    By Conrad in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-22-2005, 05:05 AM
  7. [SOLVED] WRAP a text line over several columns without merging cells
    By Conrad S in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-22-2005, 01:06 AM

Tags for this Thread

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