Series helper, helper formula


New Member
Hope this saves at least someone some time. There are probably much better ways to bo this with xml, however, this formula will allow you to cut and paste series info into a spreadsheet and reformat it into series helper file format.

  • copy and paste the series info from the tvdb into a spreadsheet
  • use this formula in the next free column
=B1&" ==> S"&TRIM(LEFT(A1,1))&" - "&SUBSTITUTE(RIGHT(A1,2)," ",0)

  • copy it down to the rows requred by your data
  • copy paste special the result into a new column and just select text & numbers
  • copy the new column to your text file
Makes my life easier so thought I would share.