I've searched around already and couldn't find an answer to this -- pardon if it's been asked and answered already!

I've attached a photo to illustrate the dilemma. So I've sorted the data by call #, title, then serial #, but the volumes aren't sorting properly (i.e, vol. 1, vol. 10, vol. 2, vol. 20, etc.). I think it's because Excel is reading the data as text instead of numbers. Short of getting rid of the "vol." before the integers (I have over 9000 rows!!!), is there a way to sort this properly?

My data:

[![my data](https://i.stack.imgur.com/zvu3C.png)](https://i.stack.imgur.com/zvu3C.png)