If that is the case, the best (and easiest) solution may be to reformat the worksheet so that the sort key is in a column all by itself. If there are more, or less, then the solution becomes more difficult. There is one assumption made in this solution-that there are only two lines in each cell of column A. You can then easily sort based on the information in column B. This solution results in column B containing the information on the second line of the first column. The RIGHT function returns the characters in the cell starting at the character following the Alt+Enter character. In this formula the FIND portion determines the position of the Alt+Enter character (the character code of this character is 10). Obviously the cell references will change when placed in column B.
(This column could be hidden so it doesn't show up when normally working with the worksheet or when printing it out.) The following formula should then be placed in each cell of column B: Perhaps the best way to complete such a task is to insert a new column in the worksheet-column B. (The user pressed Alt+Enter to separate the first name from the second name within the same cell.) What if you need to sort the rows in the worksheet based on the last name of the person? For instance, you might inherit a file in which the first column contains a person's first name on the first line, then their last name on the second line. Some of these files can be pretty different than the files you might create. It is not unusual in an office environment to work with Excel files created by other people.
0 kommentar(er)
