Hello All,

Can someone please help me?

I am trying to split one cell into two by dividing it at the first
underscore in the text.
I don't know how many characters will be before or after each first
underscore.

For example, Cell A below would be divided into cells B and C with the first
underscore being eliminated.

Cell A Cell B Cell C

1-DEPRASST_TRANS 1-DEPRASST TRANS
1-ACC2-DEPR_TRANS 1-ACC2-DEPR TRANS
2-OTHDED_SHOLD_EXP 2-OTHDED SHOLD_EXP
1-OTHCURRL_DEFINCOME 1-OTHCURRL DEFINCOME

I've been trying all kinds of formulas in cells B and C with no luck. This
has been driving me crazy.

Thank you in advance.

RJF