| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search column - return row found in long text string
All -
Looking for a way to search column C for a 9 digit number that resides in cell A1. I would like to return the row number of any matches to cell B1. I use the =MATCH function which works except some of the cells in column C contain text greater than 255 characters (which appears to be the functions limit) and the function errors out. Any ideas? Any help is appreciated. -Jay |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
| return text value found most frequently in a column | Excel Worksheet Functions | |||
| Search text string for ssn and copy to new column | Excel Discussion (Misc queries) | |||
| search for date in long string of text | Excel Discussion (Misc queries) | |||
| Return text found in a search | Excel Worksheet Functions | |||
Threaded Mode
