+ Reply to Thread
Results 1 to 6 of 6

Moving data from one cell into multiple cells - "Text to Columns" not working

  1. #1
    Registered User
    Join Date
    08-07-2012
    Location
    California
    MS-Off Ver
    Excel:Mac 2011
    Posts
    3

    Moving data from one cell into multiple cells - "Text to Columns" not working

    Hi All,

    I have a spreadsheet where I have a column full of cells that have short sets of lines (in each cell) that need to be separated into different cells. I've tried the text to column function, and it doesn't work. It just deletes everything under the first line. I'm not very excel savvy, so I don't know much about macros or formulas. Please let me know if you can help and if you need any additional information. The spreadsheet I am working on is confidential, so I had to make an example of it with only one cell and generic names. Check each tab and it should give you an idea of what I'm trying to ask for, since it's hard to explain.

    Thanks!

    Alex
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,380

    Re: Moving data from one cell into multiple cells - "Text to Columns" not working

    try
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-07-2012
    Location
    California
    MS-Off Ver
    Excel:Mac 2011
    Posts
    3

    Re: Moving data from one cell into multiple cells - "Text to Columns" not working

    Hi Jindon,

    Thanks for your help. I tried this Macro, but all it did was duplicate the cells to a new column. It didn't actually divide out the information into separate cells. Any more thoughts? Thanks!

    Alex

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,380

    Re: Moving data from one cell into multiple cells - "Text to Columns" not working

    Try change
    Please Login or Register  to view this content.
    To
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-07-2012
    Location
    California
    MS-Off Ver
    Excel:Mac 2011
    Posts
    3

    Re: Moving data from one cell into multiple cells - "Text to Columns" not working

    Perfect!!!! Absolutely exactly what I needed. Thank you so much!

    Alex

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,380

    Re: Moving data from one cell into multiple cells - "Text to Columns" not working

    You are welcome.

    I missed "Excel:Mac 2011"...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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