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

try

Please Login or Register  to view this content.

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

Try change

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

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

Alex

You are welcome.

I missed "Excel:Mac 2011"...