Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Does anybody know if there is a way to do this. Say I
have a list of words Car Apple Fan House Fork Say I have a text string in one cell such as <B"My car is in the house in my garage"</B. I want to put a formula into the cell next to this text string and then do the following. What I need is some sort of function or formula that will look at my list of words and tell me which words on the list are in the text string and then mark the cell with what words it found. In this example in my text string are the words "House" and "Car", so I would want the formula to put into the cell an "H" telling me it found the word "House" and a "C" telling me it found the word "Car" So the final result in my cell where the formula is would be "HC". Is this possible? Boy, if you could help me with this it would be greatly appreciated. Thank You |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing a specific character type in text string | Excel Discussion (Misc queries) | |||
fixed column width with text string | Excel Discussion (Misc queries) | |||
Finding Partial Text in a Cell | Excel Worksheet Functions | |||
Formating a text string? | Excel Discussion (Misc queries) | |||
Newbie: How to search a text string from right | Excel Worksheet Functions |