buckeyebrian
New Member
- Joined
- Sep 13, 2006
- Messages
- 3
I am trying to develop a macro that takes cells that have multiples lines in them and converts them to individual rows. The spreadsheet I am working on had single cells that look like this
Lehr Timing
Coating Challenge
20 min - color change
All of that information is in one cell. What I need to be able to do is split that cell into three cells so that each cell contains one line of the orignal cell. Does anyone have any idea of how to do this? The data that is put into the cell is not consistent so I don't believe there is a way to use the transpose and text to column method. Any help with this would be greatly appreciated.
Lehr Timing
Coating Challenge
20 min - color change
All of that information is in one cell. What I need to be able to do is split that cell into three cells so that each cell contains one line of the orignal cell. Does anyone have any idea of how to do this? The data that is put into the cell is not consistent so I don't believe there is a way to use the transpose and text to column method. Any help with this would be greatly appreciated.