Originally Posted by mbovenka
Try something like (in Bulk Edit -> Search & Replace):
Search field: Author
Search for: ".* - " (without the quotes)
That should result in just the number remaining.
Destination field: series_index
Note that the Series field must be filled already, or this will not work; you can't have a series_index of a nonexistent Series.
That worked great, if you have the time could you explain the expression ".* -"?