Suppose a worksheet contains a column of part numbers that include text and numbers. A manager wants to subset the worksheet to include only the rows that start with the letters "win" and end with "s".
If you want to subset using both capital and lowercase letters (for example, win, Win, WIN), include the LOWER function, for example, LEFT(LOWER(C1),3)="win". For more information, go to Calculator functions.
Minitab creates a new worksheet that contains only the data for parts that begin with "win" and end with "s".