I wish I had the code already done for you, but in Excel VB you could figure out the best logic to search for on that column. So in your example if a single one is always in the form of C# where the number of digits is always one, then keying off the length of the cell would be easiest. Then if the C# after the dash is always a single digit you could grab it from the right command and then use that variable in a loop to create your desired result where the string variable would be add the correct format. Some quick hints:
Cells(x,y).Value gets a string value of the cell
InStr(1, <variable_string_from_cell>, "-") will return the position of the "-" in integer form
Right(Cells(x,y).Value, 1) returns the right value as a string
Then set a variable c_num to set C# based on the i in the loop i = 1 to r (being the InStr from above)
Probably the easiest would be a next statement and if i = 1 then final_output = c_num else final_output = final_output + ", " + c_num
Coding isn't exact but should get you going in the correct direction.
