Hi there,
i trying to write a formula in excel where it searches within a cell for text i.e "(I1xyz)", then strip out that section and leave rest of the text.
However as i have many (more than 7) text conditions to search the formula is becoming very big.
I was wondering if there is way write a VBA functions to do all these test in one go.
> look in cell e.g. b3
> case - find "(IOM)" then B3
> case - find "(I" then len no and left(b3, Len no)
> case - find "(J" then len no and left(b3, Len no)
so on etc
basically once it retunrs len no then i can just strip out that section
hope this makes sense. Can anyone help.
i trying to write a formula in excel where it searches within a cell for text i.e "(I1xyz)", then strip out that section and leave rest of the text.
However as i have many (more than 7) text conditions to search the formula is becoming very big.
I was wondering if there is way write a VBA functions to do all these test in one go.
> look in cell e.g. b3
> case - find "(IOM)" then B3
> case - find "(I" then len no and left(b3, Len no)
> case - find "(J" then len no and left(b3, Len no)
so on etc
basically once it retunrs len no then i can just strip out that section
hope this makes sense. Can anyone help.