| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Identify if a cell contains a numerical string
On Jan 15, 12:38*pm, Ron Rosenfeld wrote:
On Tue, 15 Jan 2008 09:31:26 -0800 (PST), Pierre wrote: Have a long list of identifiers: E6A3289A F9DB1200G5W KRQ7356VQ G1200GUWY87 In a helper column, we need to identify (true or false is ok) if the value in the first column contains the string 1200. Assuming data is in A1:An =COUNTIF(A1,"*1200*")0 It may appear anywhere in the cell value; it is not consistently found after or before a given number of other characters within that cell. --ron Thanks to both of you. Both work fine. Pierre |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRUNCATE SPACE FROM NUMERICAL STRING eg "33Â 033Â 546" | Excel Worksheet Functions | |||
| Identify the cell with Max & Min values | Excel Worksheet Functions | |||
| In cell drop down menu with seprerate numerical target cell | Excel Discussion (Misc queries) | |||
| How to identify a cell without a formula | Excel Discussion (Misc queries) | |||
| In Excel, how do I identify the contents of a cell as numerical o. | Excel Discussion (Misc queries) | |||
Threaded Mode
