Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
testing for character strings within a cell
Is there an easy way to test the contents of a cell for a particular
character string? I have a number of records that I've dumped out of an AS400 application and need to search one column for the word "Shell". The word is only part of the cell contents and is a varying number of spaces from the beginning or end of each respective character string. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
testing for character strings within a cell
=IF(ISNUMBER(FIND("shell",A1)), "found","not found") "MKB" wrote: Is there an easy way to test the contents of a cell for a particular character string? I have a number of records that I've dumped out of an AS400 application and need to search one column for the word "Shell". The word is only part of the cell contents and is a varying number of spaces from the beginning or end of each respective character string. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
testing for character strings within a cell
Try this:
This formula returns 1 if cell A1 contains the word "shell" =COUNTIF(A1,"*shell*") This formula counts the number of cells in the range A1:A10 that contain the word "shell": =COUNTIF(A1:A10,"*shell*") Note: COUNTIF is not case sensitive. Does that help? *********** Regards, Ron XL2002, WinXP "MKB" wrote: Is there an easy way to test the contents of a cell for a particular character string? I have a number of records that I've dumped out of an AS400 application and need to search one column for the word "Shell". The word is only part of the cell contents and is a varying number of spaces from the beginning or end of each respective character string. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
How to make a cell recognize multiple text strings? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |