| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete A Word That Exceeds X Number Of Characters
"brazen234"
wrote... Search didn't turn up anything, so help would be appreciated. Simple as the title sounds. I have thousands of words in column A (one word per cell) and I would like to delete all words 20 letters or greater. Another alternative: select the range, run the menu command Edit Replace, finding ????????????????????* and replacing with nothing. Then with the range still selected, run Data Filter Auto Filter, selecting blanks, then run Edit Delete. No formulas needed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete word from multiple cells | Excel Discussion (Misc queries) | |||
| Number and Word in the same cell | Excel Discussion (Misc queries) | |||
| limit number of characters in a cell | Excel Discussion (Misc queries) | |||
| how do i filter data by number of characters in excel? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
