Text Tools

Text - Convert to Uppercase                ...Suppose you have typed a large amount of text on any sheet in Lower Case and later on you have to convert it to uppercase. In normal circumstances you can use Uppercase function for each cell but it will be very time consuming. Here, first select all the cells whose contents you want to covert to uppercase, then click and select the Uppercase function in powerutilities. All the text will be converted to uppercase.

Text - Convert to Lowercase                ...First select the range whose Text you want to convert to lower case, then apply the function. All the Text will be changed to Lower Case.

Text - Convert to Proper Case                 ...In Proper case the first alphabet of each word will be capital and the other letters will have lower case. First select the range whose Text you want to convert to Proper Case, then apply the function. All the Text will be changed to Proper Case.

and you would like to remove 121 from the beginning ie. the 1st three characters. Select the data range use the program and put 3 in the edit box and immediately the 1st 3 characters will be removed and the output would be

Text - Delete N  trailing characters...With this function you can remove a fixed number of characters at the end of each cell from the selected range of data.

Text - Delete all Leading Blank Spaces...With this function you can remove any blank space appearing at the beginning of cells. First select the range for which you want to remove the leading blank space then execute this function.

Text - Delete all Trailing Blank Spaces...With this function you can remove any blank space appearing at the end of cells. First select the range for which you want to remove the trailing blank space then execute this function.

Text - Delete all Leading & Trailing Blank Spaces...With this function you can remove any blank space appearing at the beginning and end of cells. First select the range for which you want to remove the blank space then execute this function.