+ Reply to Thread
Results 1 to 7 of 7

Splitting cells with EVERY carriage return

  1. #1
    Registered User
    Join Date
    09-30-2017
    Location
    Ryazan, Russia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Splitting cells with EVERY carriage return

    Hey guys! Could anyone tell me how to INTERACTIVELY split a sentence like "The cat likes milk" so that "likes milk" would be in a newly inserted cell just beneath "The cat" - and assign a hotkey to it? Or phaps there's a ready-made hotkey for an action like this that I don't know of?Untitled-1.jpg

    I need to be able to do it interactively since I'm performing some followup editing work. Here I need to split cells so that every bold phrase would be at the beginning of a new line and hence form a new glossary entry. (see attached)
    Untitled-2.jpg

    Regards,
    Alex

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Splitting cells with EVERY carriage return

    any chance for excel example file?

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Splitting cells with EVERY carriage return



    To attach an Excel file to your post,
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post

  4. #4
    Registered User
    Join Date
    09-30-2017
    Location
    Ryazan, Russia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Splitting cells with EVERY carriage return


  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Splitting cells with EVERY carriage return

    see post#3

  6. #6
    Registered User
    Join Date
    09-30-2017
    Location
    Ryazan, Russia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Splitting cells with EVERY carriage return - SOLVED

    well, for some unknown reason I couldn't upload the excel file.
    however, meanwhile I've managed to solve the problem.

    So,
    1. I've interactively split up the cells (Alt+enter)
    2. saved the data as a unicode txt file
    3. imported it as txt data

    voila! it worked out fine)
    Attached Files Attached Files

  7. #7
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Splitting cells with EVERY carriage return

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

    addition:
    with PowerQuery add-in for Excel 2010
    Last edited by sandy666; 09-30-2017 at 09:57 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 a cell that has many values separated by a carriage return
    By Nerpilis in forum Excel General
    Replies: 2
    Last Post: 07-01-2013, 11:44 AM
  2. Replies: 14
    Last Post: 10-26-2012, 01:42 AM
  3. Carriage return splitting into different rows
    By [email protected] in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-15-2011, 01:29 AM
  4. splitting cell data at carriage return points
    By rich80 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2008, 03:29 AM
  5. [SOLVED] How do merge two cells with a carriage return in between the two v
    By Richard in forum Excel General
    Replies: 5
    Last Post: 04-19-2006, 03:50 PM
  6. Join 2 cells with carriage return in between
    By MaxBrit in forum Excel General
    Replies: 2
    Last Post: 01-12-2006, 06:18 AM
  7. [SOLVED] Carriage Return and Splitting Lines to Lotus Notes Msg through VBA
    By skiloa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-08-2005, 11:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1