EXCEL CONCATINATE A STRING OF CELLS AND EXTRACT PARTIAL DATA FROM CELL INSIDE NEW STRING

 Hello, 

I am trying to fine tune a process that eats up a lot of my time. Basically I deliver Hyperlink files to stations around the country. My source data use to be physically typed into an email and I created a CONCATENATE function to create a string of data to copy and paste inside of an email along with a hyperlink in the cell to the right.

Please see screen shots below: 

' SCREENSHOT 1 (SOURCE DATA)

   Screenshot 2 (Output Data)

Ultimately, I am trying to Take data from "H2/LENGTH(S)" AND CREATE EMAIL LINE 1 TO SHOW 'CAMPAIGN NAME 30 (800-000-0000 -' rather than the entire contents of "H2/LENGTH (S)"

Here is my current output: 'CAMPAIGN NAME 30/60 (800-000-0000 -'

Here is how I would like it to output for 'Email Line 1' - 'CAMPAIGN NAME 30 (800-000-0000 -' 

Secondly, I would like Email Line 2 to take the second portion of the data from 'H2/Length (s)' and produce this output: 

Here is how I would like it to output 'Email Line 2' - 'CAMPAIGN NAME 30 (800-000-0000 -' 

Today I copy the entire output into an email and have to manual change the lengths since their are individual 'hyperlink files' for each Email Line. 

Lastly, Is there a function that could add a symbol to the beginning of the Email Line 1/ Email Line 2/ Email Line 3 etc inside this function? IE (Bulletpoint Symbol CAMPAIGN NAME 30 (800-000-0000 -