52.2 Developing a comprehensive training program A training program is composed of a schedule of activi-ties with training goals, learning objectives, subject areas, methods, trainers, trainees, methods of assessment, and locations.
Excel 2010. Posts. 547. Re: split single cell into two horizontally You cannot split an Excel cell. Neither into columns nor into rows. That works in Word and PowerPoint tables, but not in Excel. Excel allows you to merge cells, but that creates more headaches than the chemist has pain killers for.
Select a blank cell you want and right click to select Transpose(T), then you can see the data has been converted into multiple rows. See screenshot: If you are using Microsoft Excel 2007, click the Home > Paste > Transpose to paste the split data. Convert one cell to multiple cells/rows with VBA. If you think the above method is a little tedious, you can use a VBA to get it done.