| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to detect characters with a cell?
Under cell A1, which contains a link to file C:\ABC\[Sample.xls]Sheet1!A1.
In cell B1, I would like to detect whether cell A1 contains "ABC" characters inside this path, if yes, then return String "ABC", else nothing "". Does anyone have any suggestions? Thank in advance for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to detect #N/A and return 0? | Excel Discussion (Misc queries) | |||
| Function to detect type of cell contents | Excel Worksheet Functions | |||
| Can I use a function to detect whether a cell is highlighted? | Excel Worksheet Functions | |||
| detect cell color and count it | Excel Worksheet Functions | |||
| Is there a function to detect changes in any given cell? | Excel Worksheet Functions | |||
Threaded Mode
