+ Reply to Thread
Results 1 to 4 of 4

HELP splitting out text in one cell into many rows quickly

  1. #1
    Forum Contributor
    Join Date
    03-16-2013
    Location
    london
    MS-Off Ver
    Excel 365
    Posts
    137

    HELP splitting out text in one cell into many rows quickly

    Hi

    I have attached an example of an excel spreadsheet and i need help splitting it out column O into different rows ie 1), 2), 3) on different rows but the rest columns need to be the same.

    Let me know if you have any questions

    Please can someone help ASAP
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,250

    Re: HELP splitting out text in one cell into many rows quickly

    first, are you still using Excel 2010? if not, please update your profile with your current Excel version (oldest if there are multiple Excel versions being used)..

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

  3. #3
    Forum Contributor
    Join Date
    03-16-2013
    Location
    london
    MS-Off Ver
    Excel 365
    Posts
    137

    Re: HELP splitting out text in one cell into many rows quickly

    Hi I am using excel 365 and i have updated this.

    Please see attached answer

    You can see column O only gets split and rest remains the same due to control activites per risk activity.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,250

    Re: HELP splitting out text in one cell into many rows quickly

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by JohnTopley; 11-06-2024 at 08:43 AM.

+ 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. [SOLVED] Splitting Text Field in to Rows
    By Martin_246 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-21-2022, 10:28 AM
  2. [SOLVED] Highlighting every next rows after a row containing specific text and splitting rows
    By Khalid.Noor in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-24-2018, 04:44 AM
  3. Splitting dates and inserting rows quickly
    By ola7mat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2017, 12:27 PM
  4. Quickly edit text of a hyperlinked cell?
    By so57x in forum Excel General
    Replies: 1
    Last Post: 01-26-2017, 02:21 PM
  5. splitting text into rows.
    By rose9812in in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-14-2015, 09:44 AM
  6. Macro splitting comma delimated cell text into rows with other row data copied...
    By geoffffffff in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-13-2013, 11:07 AM
  7. [SOLVED] Splitting text from one cell into separate text fragments, Located in adjacent cells
    By onsid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2013, 08:32 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