Extracting Number of Characters

[Excel-Access]

Dear Excel Community

Can someone kindly advise the best formula to use for Column C in the attachment

In Column A I have SD0350 - No. of Customers Numbers

Column B should extract SD0350 and I have used =LEFT(A2,6)

Column C should extract No. of Customers Numbers and that is where I am stuck

I have about 350 rows to perform this task.

I welcome any suggestions my friends

Thanks

[Jonmo1]

A2 A3 and A5 have a space before the hyphen.
A4 does not

Is that just a typo, or will there sometimes be the space, and sometimes not?

If that was just a typo, and the space will always be there
Then you can use
=MID(A2,10,155)

[Excel-Access]

Jonmo1

Many thanks for your prompt reply.

It was a typo by me but your suggestion has saved me a lot of time.

Most grateful to you.

[Jonmo1]

You're welcome..

Turns out I had a typo of my own there.
In intended that last number to be 255, not 155..
No real reason, it's just meant to be a number that is larger than the length of the original string.