Able2Extract and Able2Extract Professional contain a “Custom” Excel conversion option that lets users insert column breaks to ensure that columns are correctly lined up within Excel. It is a great tool that delivers accurate results when the automatic conversion is not able to do so. The following is a quick tutorial on how it works:

Using the Excel “Custom” Conversion Feature
The Excel “Custom” conversion solution lets you manually add and re-position as many vertical lines as required to designate the column breaks for the conversion into Excel.

1. Vertical Lines
   Adding Vertical Lines – Click your mouse RIGHT BUTTON to add vertical lines (as many vertical lines can be added as required).
   
   Removing Vertical Lines - Position mouse pointer over Vertical Line. Double RIGHT CLICK mouse button to remove.
   
   Re-Positioning Vertical Lines – Position mouse pointer over Line. Hold down mouse RIGHT BUTTON and move either left or right.
   
   
   
   
2. Horizontal Lines
   There are two horizontal lines in total. One at the top of the page and one at the bottom. Additional horizontal cannot be added. Horizontal lines are used to designate page headers and footers.
   
   Removing Horizontal Lines - Position mouse pointer over Horizontal Line. Double RIGHT CLICK mouse button to remove.
   
   Re-Positioning Horizontal Lines – Position mouse pointer over Horizontal Line. Hold down right mouse button and move either up or down.
   
   
   
   
3. Selecting Data
   Selecting Data to Convert – Hold mouse LEFT BUTTON down and highlight data you wish to convert. Or, use the selection options available in the Edit Menu.
   
   
   
   
4. Completing Conversion
   When completed re-positioning the lines and selecting Data, Click on the “E” icon on the toolbar.