Hi,

I am trying to parse text from one column to another. What I want to parse is all text before an underscore and the text after the underscore upto the next underscore e.g.:

1_AveP_6.1_MG5

to become

1_AveP

or

13_Hoo_10.1_H2

to become

13_Hoo

The following gives me all after the first _ and this is where I am
confused on how to adapt it.

=IF(ISNUMBER(SEARCH("_",S2)),RIGHT(S2,LEN(S2)-SEARCH("_",S2)),S2)

Can you help please?

Many thanks

Brian Miller