Num_chars return characters vary from cell to cell

[LoveUsingExcel]

In the mid function, is there something special to use in the Num_chars field when the characters to be returned will vary? In the examples below, I want everything after the space dash space, so character 14. But the number to return after that will be different from cell to cell. I just keep using a number that I know is big enough, but am just wondering if there is a better way.

=MID(D20,14,50) 12345678901 -ab cde fg hi
=MID(D21,14,50) 23456789012 -jklm nop qrstu vwx yz

Thanks!

[Ace_XL]

Why not use..

=RIGHT(D20,LEN(D20)-FIND("-",D20))

[Jonmo1]

It's OK for that num_chars argument to be larger than it needs to be, provided your intention is to return ALL text after the certain starting point.

But instead of having to guess at a number that is large enough, you can use the LEN function
=MID(D20,14,LEN(D20))

If you wanted to be precise and get the absolute correct # you could then subtract the 14 from the LEN
=MID(D20,14,LEN(D20)-14) <- but completely unnecessary to do that.

[LoveUsingExcel]

Thank you both for your response. I'm showing some co-workers a few basic functions and was trying to keep it simple for them. But I will try both suggestions on my own spreadsheets.