In the bulk edit metadata screen, there's a search & replace option. What you want is possible using the regular expression search mode. You'll need to do two passes: In the first one, place 'series_name [index]' in the series field. This will set the series_name and series_index of the books. In the second, remove everything you don't want from the title field.
There's a
tutorial on regular expressions available, should you need it.