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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find text within cell
Paula,
Try this. Drag down as required. =IF(SEARCH("LHR-SEA-LHR",A1),"It's Here", "Not Here") Mike "Paula" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find text within cell
Thanks Mike, I'll try it, thanks for coming to the rescue again... don't know
what I would do without this group, but I do know my formulas are getting a bit better as I learn. Thanks and have a nice weekend. "Mike H" wrote: Paula, Try this. Drag down as required. =IF(SEARCH("LHR-SEA-LHR",A1),"It's Here", "Not Here") Mike "Paula" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find text within cell
hi, I have found the following works good for being abe to modify from one
location. it would used defined names (e.g.: Ab, by: Insert, Name, Define): enter: ={3;6;9;"c";"C"} or ={"LHR-SEA-LHR";"DXB-AMS"} name it anything/ Ab for: =IF(SUMPRODUCT(--ISNUMBER(FIND(Ab,F9)))0,"yes","no") "Paula" wrote: 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 |
Reply |
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) |