Combining Concetantion Formulas & Adding Formula to Copy Formula Value to an Actual Value

Hello,
I am attaching a sample worksheet where I am trying to combine two CONCATENATE formulas (one in column B and one in column C). Column A contains a project number. The end result needs to be added to an application to search for these project numbers (this will be a template, so the project numbers in column A will change).

=CONCATENATE(A2,";"," ")
=CONCATENATE(B2,B3,B4,B5,B6,B7,B8,B9,B10,B11,B12,B13,B14,B15,B16,B17)

Last item in this request is if there is a formula that will take the formula value produced in column C (the string of the project numbers separated by the semi colon and space) and change that to an actual value.

Any help with this would be greatly appreciated!

P.S. - If there isn't a way to take the formula values and make them actual values, that is fine - My first priority is getting a formula that combines the actions in Columns B and C.

if you had Excel 365 you could just use the Textjoin function:

=TEXTJOIN("; ",TRUE,A2:A17)

Try

=CONCATENATE(A2&"; ",A3&"; ",A4&"; ",A5&"; ",A6&"; ",A7&"; ",A8&"; ",A9&"; ",A10&"; ",A11&"; ",A12&"; ",A13&"; ",A14&"; ",A15&"; ",A16&"; ",A17)

Or if you have Office 365 or a more recent version of Excel use
=TEXTJOIN("; ",TRUE,A2:A17)

or

=CONCAT(A2:A17&"; ")
(array-entered)