Hi all,

I know this is probably an easy one, but i can't find an answer.

In cell A1 I have these possible values:

2-10
2-8
22-8
22-10

The actual numbers vary, but there are 4 possible length scenarios, and the delimeter is always "-".

What I am trying to achieve is to have the number before the "-" character appear in cell B1, and also have the number which appears after the "-" sign go into C1.
I've looked at LEFT, RIGHT and MID functions, aswell as LEN and SEARCH and FIND, but I just can't make these work together.

If anyone could help solve this for me, I can then hopefully have a base to work from for future problems.

Thanks,

Yappa.