Data Conversion Tools with Add-ins/plug-ins for Excel
 

Split Text to Rows

The tool Split Text to Rows allows you to split text contained in the cells of a single column and vertically transpose separated fields on the rows of such column, replicating cells with data that go along with each original cell of the split column in the selected adjacent columns as part of the entire data area.    

It is possible to apply one or more delimiters to perform the fields division.  

The output will be generated in a new workbook without affecting original data.  

This tool works similarly to the one named Transposing Cross Tables


Copyright © 2008-2017 Databilio. All rights reserved.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation
in the United States and/or other countries.
 
Secure Purchase


Buy NOW

Buy Report Inverter for Excel