XLEcom Version 3.3 Released

XLEcom Version 3.3 Released

Version 3.3 (3.3.411) released on September 8, 2005

New Features:

Database Utilities
Use these utilities to clean up your Product Ad values contained within the Database sheet.

Note: This utility will only function on cells that contain less than or equal to 254 characters. Cells that either contain more than 254 characters or have formulas will be skipped.

Database Utilities Operations

  • Remove Line Breaks - Removes all Line Breaks by using the CLEAN() function.
  • Replace Line Breaks with: - Replaces all Line Breaks with the entered text. (<br> = HTML line break)
  • Remove Extra Spaces - Removes all Extra Spaces using the TRIM() function.
  • Convert Text to Numbers - Converts Text Numbers to actual Numbers.
  • Convert Numbers to Text - Converts Actual Numbers to Text Numbers.
  • Convert to Upper Case - Convert all text to Upper Case using the UPPER() function.
  • Convert to Lower Case - Convert all text to Lower Case using the LOWER() function.
  • Convert to Proper Case - Convert all text to Proper Case using the PROPER() function.
  • Add a Bullet Prefix (•) - Adds a Bullet Prefix (•) to all entries.
  • Remove All Bullets (•) - Removes all Bullets (•) within all entries.

Target Cells
Selected Database Field - If you choose this option, you will also have to select a database field from the drop down scroll box to perform the operation on all entries within the selected field.

Custom Selection (select to choose cells) - If you choose this option, you will be prompted to select a range of cells on the Database sheet to perform the operation.

Sam Raheb
XLEcom Program Developer


Database Utilities
Below is a screen shot image showing the newly added Database Utilities feature.