Anyone know how I can quickly extract JUST two letter words from an excel column? EG: If the column contains these: this is entry one entry two this is entry fivce entry three I can easily sort it so entry two and entry three are on top, or remain - and the entries bigger than 2 words get sorted to the bottom or deleted?
Add to each row a new cell that counts the number of spaces in the cell you want to sort by. Use this formula in that new cell to count the spaces: =1 + SUM(LEN([CELL])-LEN(SUBSTITUTE([CELL]," ","")))/LEN(" ") PHP: Replace '[CELL]' with a reference to the cell you want to count the spaces in. This will create a column of numbers that you can then sort by.