XLplus Add-On: Sort In Cells
This XLplus Add-On sorts the content of each cell of the active selection.
Example: You have a list of cities within one cell, which you want to be sorted. The cities are delimeted by a semicolon. You specify the delimeter and sort order and retrieve text lists of sorted cities.
The data is now sorted descending. As you can see, you can sort any data given as a list.
Delimeter:
Determine the character, which is used to identify each single value of the list. Possible delimeters are:
Alternatively, enter your desired character or phrase.
Sort Order:
Choose whether to sort in ascending or descending order.
Sort as String or Number
Specify, whether content of cells of your selection shall be treated as string or number when sorting. When sorting as numbers but cells contain only or partly characters a warning will be shown. You can sort these cells as String, afterwards.
Versions:
Ver.: 2.0.13 and Ver.: 3.0.13 added option Sort as String or Number.
See also:
XLplus Add-On: Color Management
XLplus Add-On: Shape Comments
XLplus Add-On: Rework Comments
XLplus Add-On: Automate Headers and Footers
XLplus Add-On: Remove Print Settings
XLplus Add-On: Copy + Paste Without Empty Ranges
XLplus Add-On: Copy Multi Areas
XLplus Add-On: Copy SubTotals
XLplus Add-On: Worksheet Protection
XLplus Add-On: Read Assistance
XLplus Add-Ons Overview
XLplus Overview