Home |
Search |
Today's Posts |
#1
|
|||
|
|||
search cell for specific text.
Hello everyone!
I hope that one of you can help me with the following challenge (Excel 2010): I need to search a cell (text) for three specific strings of text (so one of the values needs to be in place)(might be in between other text) and if that cell holds one of those three specific text strings then print that string in another cell. I have searched the internet and i cannot seem to find the sollution for this. I really hope that one of you can help me with this because i'm stuck on this. Very very kind regards, Tom. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search cell for specific text.
vonsharkel formulated on Monday :
Hello everyone! I hope that one of you can help me with the following challenge (Excel 2010): I need to search a cell (text) for three specific strings of text (so one of the values needs to be in place)(might be in between other text) and if that cell holds one of those three specific text strings then print that string in another cell. I have searched the internet and i cannot seem to find the sollution for this. I really hope that one of you can help me with this because i'm stuck on this. Very very kind regards, Tom. Have a look at the FIND() function in the online help. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for specific text within last non blank cell in a range | Excel Worksheet Functions | |||
Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
Search for cells that DO NOT contain specific text | Excel Programming | |||
Looking for a way to search for specific text across columns | Excel Worksheet Functions | |||
How do I search for specific text and sum the cell to the right? | Excel Worksheet Functions |