With this nifty add-in you can quickly clean your data imported from an external source. It will help you remove leading and trailing spaces, excess spaces between words, non-breaking spaces, line breaks, non-printing characters and other unwanted symbols. You can also convert words to a proper case: UPPER, lower or or Proper Case; change numbers stored as text to number format and delete apostrophes. The add-in works with Excel 2003-2010.
Save each row or column as a text file in one or many MS Excel files. Each cell in a text file can be separated by an enter, comma-space, comma, space, etc. Excel 2000 or higher required.
Downloads: 112157 - Shareware - Download Now
Sort a group of selected cells in MS Excel using different methods. Character position, word, user-specified, alphabet, numeric, alphanumeric, backwards (reverse), text length, character count, format, fill color, font color, date, year month, day.
Downloads: 100405 - Shareware - Download Now
Use MS Excel as a front-end interface to a Sybase ASE database. Use Excel to import and export tables to and from Sybase ASE databases. Read and write tables to and from Excel without SQL knowledge. Excel 2000 or higher required.
Downloads: 109051 - Shareware - Download Now
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.
Downloads: 66830 - Shareware - Download Now
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.
Downloads: 83301 - Shareware - Download Now