| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function that searches cell for string?
Is there a function that can search a given cell to find a given string? For example, I'm hoping to find a function that can tell if the word 'Travis' is in a cell that may have a number of names seperated by commas (Dan, Travis, Leo). Thanks! -- IanMcGreene ------------------------------------------------------------------------ IanMcGreene's Profile: http://www.excelforum.com/member.php...o&userid=37247 View this thread: http://www.excelforum.com/showthread...hreadid=570075 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function that searches cell for string?
The standard Find feature should accomplish this. Edit - Find. Be sure to
uncheck "Find entire cells only". "IanMcGreene" wrote in message ... Is there a function that can search a given cell to find a given string? For example, I'm hoping to find a function that can tell if the word 'Travis' is in a cell that may have a number of names seperated by commas (Dan, Travis, Leo). Thanks! -- IanMcGreene ------------------------------------------------------------------------ IanMcGreene's Profile: http://www.excelforum.com/member.php...o&userid=37247 View this thread: http://www.excelforum.com/showthread...hreadid=570075 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function that searches cell for string?
No, I need a funcion call. I'm not simply trying to find something in the cell, I'm looking to find a string and then act on it at another cell. -- IanMcGreene ------------------------------------------------------------------------ IanMcGreene's Profile: http://www.excelforum.com/member.php...o&userid=37247 View this thread: http://www.excelforum.com/showthread...hreadid=570075 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function that searches cell for string?
Ian,
I think that would be the "=SEARCH()" feature. it won't matter what case it finds, upper or lower... Beege "IanMcGreene" wrote in message ... Is there a function that can search a given cell to find a given string? For example, I'm hoping to find a function that can tell if the word 'Travis' is in a cell that may have a number of names seperated by commas (Dan, Travis, Leo). Thanks! -- IanMcGreene ------------------------------------------------------------------------ IanMcGreene's Profile: http://www.excelforum.com/member.php...o&userid=37247 View this thread: http://www.excelforum.com/showthread...hreadid=570075 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function that searches cell for string?
There are FIND and SEARCH worksheet functions that do this.
"IanMcGreene" wrote: No, I need a funcion call. I'm not simply trying to find something in the cell, I'm looking to find a string and then act on it at another cell. -- IanMcGreene ------------------------------------------------------------------------ IanMcGreene's Profile: http://www.excelforum.com/member.php...o&userid=37247 View this thread: http://www.excelforum.com/showthread...hreadid=570075 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function that searches cell for string?
Yes, But the problem comes in when the text does not exist in the cell.
Then the result is an error. Sorry, though, I do not have the answer. "KePaHa" wrote in message ... There are FIND and SEARCH worksheet functions that do this. "IanMcGreene" wrote: No, I need a funcion call. I'm not simply trying to find something in the cell, I'm looking to find a string and then act on it at another cell. -- IanMcGreene ------------------------------------------------------------------------ IanMcGreene's Profile: http://www.excelforum.com/member.php...o&userid=37247 View this thread: http://www.excelforum.com/showthread...hreadid=570075 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function that searches cell for string?
i could really use this equations also. thanks!
PCLIVE wrote: Yes, But the problem comes in when the text does not exist in the cell. Then the result is an error. Sorry, though, I do not have the answer. "KePaHa" wrote in message ... There are FIND and SEARCH worksheet functions that do this. "IanMcGreene" wrote: No, I need a funcion call. I'm not simply trying to find something in the cell, I'm looking to find a string and then act on it at another cell. -- IanMcGreene ------------------------------------------------------------------------ IanMcGreene's Profile: http://www.excelforum.com/member.php...o&userid=37247 View this thread: http://www.excelforum.com/showthread...hreadid=570075 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function that searches cell for string?
Try =IF(ISERR(FIND("mike", B4,1)), "Error", "No Error") - this does one thing
if the FIND results in an error an another if it finds a match. "Beege" wrote: Ian, I think that would be the "=SEARCH()" feature. it won't matter what case it finds, upper or lower... Beege "IanMcGreene" wrote in message ... Is there a function that can search a given cell to find a given string? For example, I'm hoping to find a function that can tell if the word 'Travis' is in a cell that may have a number of names seperated by commas (Dan, Travis, Leo). Thanks! -- IanMcGreene ------------------------------------------------------------------------ IanMcGreene's Profile: http://www.excelforum.com/member.php...o&userid=37247 View this thread: http://www.excelforum.com/showthread...hreadid=570075 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Reading Cell Function??? | Excel Worksheet Functions | |||
| copying the function contained within a cell to anouther cell. | Excel Worksheet Functions | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
Linear Mode
