Split Text and match it vba function

[jessica0007]

I'm looking for a function from the formula. I hope that someone will help me.
we want to search for such text "TP" and "IP" before the number.

[Richard Buttrey]

Hi,

Are you looking for a User Defined Function in VBA which is equivalent to your formula?

If so do you intend to leave B7 & B9:10 blank? I so what's the rule for ignoring A7 & A9:A10.
Is it simply that the first two alpha characters must be followed by a numeric?

[Richard Buttrey]

Hi,

Here's one way

Please Login or Register  to view this content.

[jessica0007]

Thank to the Reply,
Yes, I am searching for functions similar to my formula.
Perhaps you have not seen the entire formula, the formula is divided into three parts.
In the first step, the text is divided by numbers and in the second step, the text matches "TP" or "IP", and in the third and final stage, if the text is not with "TP" or "IP" If the match is in such a situation, it will leave the empty cell.
it is only to try to find such text "TP" and "IP" before the number.

[jessica0007]

This function does not work properly as my expectation.

[jindon]

B2
=GetTPIP(A2)
then filldown

Please Login or Register  to view this content.

[jessica0007]

Thank you jindon, Yes that's it what i wanted.

[jindon]

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[Richard Buttrey]

Thank to the Reply,
Yes, I am searching for functions similar to my formula.
Perhaps you have not seen the entire formula, the formula is divided into three parts.
In the first step, the text is divided by numbers and in the second step, the text matches "TP" or "IP", and in the third and final stage, if the text is not with "TP" or "IP" If the match is in such a situation, it will leave the empty cell.
it is only to try to find such text "TP" and "IP" before the number.

Did you actually try the function? It provides the answers you show in your example.
The function doesn't rely on any particular first two characters, it simply identifies whether there is a numeric in the 3rd position and if so returns the first two characters.
If you have other data where the result needs to be different then plesae show it.

See attached