| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How Do I Find Different Values In A String?
I have some part numbers in a string format in column A.
I want to know which ones include the sub-strings "VI", "EP", "PAR", "BU". Luckily, only one of these four values can be in each part number. There are no instances where a part number has two, three, or all four of the above sub-strings. So I wrote the following formula: =find(or("VI","EP","PAR"),a2) ....but it does not work! What do I need to do to make it work? -- tb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need a formula to find "*" in s string and multiply by preceding andfollowing values | Excel Discussion (Misc queries) | |||
| hi, how to compare two string values, if the string values r from inputbox in VB | Excel Programming | |||
| Find a string in a range and return two values based on offsets | Excel Programming | |||
| How to find values in string? - Urgent! | Excel Discussion (Misc queries) | |||
| Dynamic Find and Replace String Within Functions Based on Column Values | Excel Programming | |||
Threaded Mode
