| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find text within cell
Hi,
I have a column where the cell contains vaiable information, and I want to find any cell which contains LHR and SEA and LHR again, the format of the text will be variable in length and separators and will not always contain these 3 codes, a couple of examples of what the string will look like are below: AMS/DXB-AMS/LHR-SEA-LHR/AMS DUB-/AMS/LHR-SEA-LHR-AMS-DUB any ideas of formulas that will find a cell which contains sea and lhr within it? Rgds Paula |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find cell address of last cell in a column with text | Excel Worksheet Functions | |||
| FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
| Find text in a cell and copy text to another cell | Excel Discussion (Misc queries) | |||
| find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
| Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
Threaded Mode
