• The forum software that supports hummy.tv will be upgraded to XenForo 2.3 on Wednesday the 20th of November 2024 starting at 7pm

    There will be some periods where the forum is unavailable, please bear with us. More details can be found in the upgrade thread.

Series helper, helper formula

S

stewartm

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.

Usage:-
  • 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.
 
You must log in or register to reply here.
Back
Top