Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello all!
Does anyone know how I may be able to search a string and extract text from it using the MID and FIND function with multiple FINDS? I have a spreadsheet for which I have a lengthy bit of text for which I have set up to currently extract ",IE". I need to adapt the formula =MID(Dump!A1,FIND(",IE.",Dump!A1)-2,5) to also search for either ",MA" or a ",MC". These characters will always be unique and there will not be a combination of either in the text string. The string will have either one of the three but not two or all of them. I thought there may be an OR function I could use but am having no luck. Thank you for your time any any help you may be able to provide. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use of Find with Left, Mid, Right functions in nested IF(and('s | Excel Discussion (Misc queries) | |||
Nested IF, reports incorrectly, can't find anything like it to ref | Excel Worksheet Functions | |||
Calc cost pro rata (nested IF's and macro to find empty row) | Excel Worksheet Functions | |||
nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
Nested If statement to find greater than but less than numbers | Excel Worksheet Functions |