| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking for a way to search for specific text across columns
I need to figure out a way to search a range of cells for "comments=". The
problem is that there are people's comments after the equals sign so the cell may contain the text string with other text. I then need to be able to remove the text string "comments=" and put the remaining results into a different cell. This one has really thrown me for a loop. The comments could be in any column A through K. I can't even figure out how to find cells that CONTAIN "comments=", everything I have tried has required an exact match of the entire cell . If anyone could help I would really appreciate it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TEXT TO COLUMNS WITH LEADING ZEROS | Excel Discussion (Misc queries) | |||
| Text Search in an Array | Excel Worksheet Functions | |||
| I need to freeze some vertical text on some columns in the midle o | Excel Discussion (Misc queries) | |||
| Text Search Macro? | Excel Discussion (Misc queries) | |||
| How do I search for text within text? | Excel Discussion (Misc queries) | |||
Threaded Mode
