Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi, everyone.
I am working on a rather large document so searching it manually isn't possible. I need to find all cells in this document (a text document imported as a tab-delimited file) that have more than 64 characters. Although I have found reference to the LEN function in Excel's help files I would prefer to work with Find and Replace command as it finds one occurrence and stops there only moving to the next if you press the Next button. Is there a way to do this with Find and Replace ? TIA, Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
FIND and REPLACE characters needed | New Users to Excel | |||
FIND and REPLACE characters needed | Excel Worksheet Functions | |||
Find cells containing a specified number of characters | Excel Discussion (Misc queries) | |||
How do I find replace special characters? | Excel Discussion (Misc queries) | |||
Find and replace unusual characters ... | Excel Discussion (Misc queries) |