by Sobolsoft Divide the contents of a single cell into multiple cells. Splits can be done by spaces, commas, or any other distinguishing character. Splits can be done quickly on a group of cells that you select. This works well if you need to break-up full names.