Excelator CTR
Price $ 29.95

OS: Window 8 and 7/ Vista/ 2003/ XP/ 2000/NT
Version 2.2.0
Publisher: Technocom

Interactive Tour - Video Tour

How to Change Proper Case in Excel?


Interactive Tour (1/17) - How to use Excel CTR:

Q 1 . How to use Excel CTR?

Excel CTR Remover - Wizard is a package of all commands in a single Dialogue Box, you can access all command from this wizard. It has two part, one is in yellow background, second in blue. See Fig.

Excel CTR

First Part - Remove
To access First Part Commands just checked on Remove CheckBox. You will see 12 useful command in Dropdown Menu. We can devide these commands in 2 categorie. One is Multiple Columns Command, Second is Single Column Commands.

Following Commands can be applied on Multiple Column Selection:

1. All Numeric Characters
Using this command you can remove all numbers (0-9) in selection.

Example: [Example 1 One] to [Example One]
Excel CTR

Interactive Tour (2/17) - Remove All Numeric Characters:

Q 2 . How to Remove All Numeric Characters?

Using this command you can remove all Alphabets (A-Z,a-z) in selection.
Example: [Example 1 One] to [ 1 ]



Excel CTR

Interactive Tour (3/17) - Remove All Alphabets Characters:

Q.3. How to Remove All Alphabets Characters?

Using this command you can remove all Alphabets (A-Z,a-z) in selection.
Example: [Example 1 One] to [ 1 ]

Excel CTR

Interactive Tour (4/17) - Remove All Spaces:

Q.4. How to Remove All Spaces?

Using this command you can remove all spaces in selected list even a single space in selection.
Example: [Example 1 One] to [Example1One]

Excel CTR

Interactive Tour (5/17) - Remove all Leading & Trailing spaces:

Q.5. How to Remove all Leading & Trailing spaces?

Using this command you can remove all Leading & Trailing Spaces in selection.
Example : [   Example 1   ] to [Example 1]
Excel CTR

Leading, Trailing & Excessive Spaces

Using this command you can remove all Leading & Trailing Spaces as well as Excessive spaces in selection.
Example : [   Example    1   ] to [Example 1]

Excel CTR

Interactive Tour (6/17) - Remove All Non-printable characters:

Q.6. How to Remove All Non-printable characters?

Using this command you can remove all Non-printable chacaters like Tab, Return Carriage etc. in selection
Excel CTR

Interactive Tour (7/17) - Remove All UPPER case Characters:

Q.7. How to Remove All UPPER case Characters?

Using this command you can remove all UPPER case (A-Z) characters in selection.
Example : [Example 1] to [xample 1]
Excel CTR

Interactive Tour (8/17) - Remove All Lower case Characters:

Q.8. How to Remove All Lower case Characters?

Using this command you can remove all lower case (a-z) characters in selection.
Example : [Example 1] to [E 1]
Excel CTR

Interactive Tour (9/17) - Remove All User-defined Character :

Q.9. How to Remove All User-defined Character ?

Using this command you can specify the characters you want to remove in selection.
Example : [Example @#$%&^"] to [Example]
Excel CTR
Following Commands can be applied on Single Column Selection:

Interactive Tour (10/17) - Remove Duplicate Values - Keep First One :

Q.10. How to Remove Duplicate Values - Keep First One ?

Using this command you can remove all duplicates except the first one in a single column selection.
Excel CTR

Interactive Tour (11/17) - Remove All Duplicate Values:

Q.11. How to Remove All Duplicate Values ?

Using this command you can remove all duplicates in a single column selection.
Excel CTR

Interactive Tour (12/17) - Remove All Unique Values :

Q.12. How to Remove All Unique Values?

Using this command you can remove all Unique values in a single column selection.
Excel CTR

Interactive Tour (13/17) - Remove Characters Conditionally :

Q.13. How to Remove Characters Conditionally ?

To access Second Part Commands just checked off Remove CheckBox. In this section you can define No. of Characters or All Characters, Start Position (SP) After or Before Start Position (SP) and Condtional Start Position. See Fig. 1.2.
Excel CTR

Interactive Tour (14/17) - Remove All Characters After nth Character :

Q.14. How to Remove All User-defined Character ?

If you want to remove all characters after 2nd Character. Just check on all Characters, enter 2 in Start Position (SP) textbox and click on After(SP)
Example : [Example One Two 1 2] to [Ex]
Excel CTR
Remove x no. of characters After nth Character
If you want to remove only 4 characters after 2nd Character. Just check off all Characters, enter 4 on white text box and enter 2 in Start Position (SP) textbox and click on After(SP)

Example : [Example One Two 1 2] to [Ex One Two 1 2]
Excel CTR

Interactive Tour (15/17) - Remove All Characters before nth Character :

Q.15. How to Remove All Characters before nth Character ?

If you want to remove all characters before 3rd Character. Just check on all Characters, enter 3 in Start Position (SP) textbox and click on Before(SP)

Example : [Example One Two 1 2] to [ample One Two 1 2]
Excel CTR
Remove x no. of characters before nth Character
If you want to remove 4 characters before 8th Character. Just check off all Characters, enter 4 in white textbox and enter 8 in Start Position (SP) textbox and click on Before(SP)

Example : [Example One Two 1 2] to [Ex One Two 1 2]
Excel CTR

Interactive Tour (16/17) - Remove all characters after 1st Space :

Q.16. How to Remove all characters after 1st Space ?

If you want to remove all characters after 1st Space. Check on All characters and check on Select Position and Choose '1st', Choose 'Space' from Select Character Dropdown menu and click on After(SP).

Example : [Example One Two 1 2 3] to [Example ]

Interactive Tour (17/17) - Remove all characters Before Last Space :

Q.17. How to Remove all characters Before Last Space ?

If you want to remove all characters before Last Space. Check on All characters and check on Select Position and Choose 'Last, Choose 'Space' from Select Character Dropdown menu and click on Before(SP).

Example : [Example One Two 1 2 3] to [ 3]

Remove x no. of characters with User-defined condition
If you want to remove 4 Characters before 5th Space. Check off All characters and type 4 in white textbox check on Select Position and type 5 in Select Postion, Choose 'Space' from Select Character Dropdown menu and click on Before(SP).

Example : [Example One Two 1 2 3] to [Example One Two 3]

Note : You can also customize Conditional Start Postion with your own Criterial. Just type Position No. in Select Position and Type the Character. It is not neccessary that character & position should be from the List. You can type your own.


X discount