|
|
Import many text files into one Excel file quickly. Load a list of text files into the program and the data will be inserted into a blank workbook. Each line of the text file can be chopped up by a specific character to create new Excel columns.
|
|
|
Merge / combine two Excel tables into one based on a common column of data from each table. A wizard makes the join process fast and easy. No complicated options. Rows from the two unequal tables will line up perfectly without copying and pasting.
|
|
|
Join (condense) cells in Excel easily. Instead of having data across many cells you can have it condensed to one. Cell merging with this tool allows content of many rows to be put into one row or content of many columns to be put into one column.
|
|
|
Use Excel as front-end GUI to your Oracle database. This interface allows for seamless import and export of tables without SQL knowledge.
|
|
|
Batch print many Excel files without having to open each one at a time. Quickly print mass amounts of xls files at once with this program. You must have Excel installed on your machine.
|
|
|
Randomly shuffle Excel cells, entire rows, or entire columns. Sorting is done quickly and at complete random.
|
|
|
Eliminate all blank rows and columns from your Excel worksheets. One option removes blank rows from the entire worksheet, the other option removes blank columns from the entire worksheet.
|
|
|
Quickly clear out text and spaces for cells in Excel using numerous methods. These methods include: removing spaces, removing alpha, numeric and more, removing characters after a word, removing characters after a certain position.
|
|
|
Delete blue underlined links in your Excel files. Load up multiple files and remove all of the hyperlinks in seconds. Excel files can be automatically backed up before hyperlink removal.
|
|
|
Quickly format cell numbers as sig. digits in Microsoft Excel. Select a block of cells to change and specify how many digits to round to.
|
|
|
Break up names or addresses in one column over many cells. Splits can be done by spaces, commas, or any other distinguishing character. Splits can be done quickly through a wizard on a group of cells that you select.
|
|
|
Change First Last to Last, First and Last, First to First Last. This program handles middle initials and suffixes (Jr, Sr, III, etc.).
|
|
|
This program will do a word frequency analysis on all the words in multiple Excel files. The program will produce a list with the number of times each word appears. You must have Excel installed on your machine.
|
|
|
Convert zip codes in Excel. Quickly change city and state to a zip code or a zip code to a city and state. Also, add leading and trailing zeros to zip codes.
|
|
|
Search for text within multiple PDF files and, if found, extract the entire line. Similarly, extract entire lines that do not contain certain text. Also, extract text between starting and ending characters throughout all files.
|
|
|
Extract the text you want from the web. Extract from multiple sites at once. Extract lines from a web site that contains or does not contain certain characters. Extract text between two characters repeatedly throughout the site.
|
|
|
Extract the text you want from the web. Extract from multiple sites at once. Extract lines from a web site that contains or does not contain certain characters. Extract text between two characters repeatedly throughout the site.
|
|
|
Search for text within files and, if found, extract the line. Extract lines that do not contain certain text. Extract text between starting and ending characters throughout files.
|
|
|
Extract email addresses from internet websites. Specify a domain and this program will extract the location of all HTML links within that domain. Then the program will extract the email addresses within those HTML links.
|
|
|
Extract email addresses from internet websites. Load a list of web addresses and the program will extract the email addresses automatically. Duplicates are automatically removed at the end of extraction.
|
