Text Value Classification dialog box

 

Use this dialog box to replace text with specified values. The values are generated by adding a multiple of Increment to the Base Value depending on the relative position of the text. You may also choose not to replace the selected text but report on the value the text strings would assume according to the different ordering options.

 

Input

Specifies the worksheet location of the input data for this operation.

 

Valid Input Range

Provides a reference to the extent of the data available in the currently active worksheet. Use this range as a guide for typing valid extents in the Input Range box.

 

Input Range

Type in this box the range of cells containing the data you want to use as input for this command.

 

Series in Rows

Check this box to indicate that the data specified by the Input Range box is organized in rows as opposed to columns (the default).

 

Refer to Specifying Input Arguments for additional information on this subject.

 

Output

Specifies the worksheet location for placing the results of this operation.

 

New Workbook

Select this option to place the results of this operation in a new document workbook.

 

New Sheet

Select this option to place the results of this operation in a new worksheet.

 

Range Position

Select this option to place the results of this operation starting at the worksheet location specified in the box to the right of this option.

 

Refer to Specifying Output Locations for additional information on this subject.

 

Value Generation

 

Base Value

Type in this box the value to be assigned to the first text string.

 

Increment

Type in this box an increment for the value of the subsequent text strings.

 

Ignore Case

Check this box to specify you want to ignore the letter case of text for discerning different text.

 

Order

 

Alphabetical

Select this option if you want numeric values assigned to text according to their relative alphabetical order, ascending or descending.

 

Occurrence

Select this option if you want numeric values assigned to text according to the order of occurrence in the document worksheet.

 

Descending

Choose this option to indicate a descending alphabetical order. This option is not available when the Alphabetical option is not selected.

 

Operation Extent

 

Replace and Report

Select this option to replace text with numerical values according to the specified rules and to generate a report illustrating text strings along with their replacement values.

 

Replace Only

Select this option to replace text with numerical values according to the specified rules only (the report is not generated).

 

Report Only

Select this option to generate a report illustrating text strings along with their replacement values only (the text is not replaced).

 

OK

Closes the dialog box and carries out this operation.

 

Cancel

Closes the dialog box without carrying out this operation.