Do you want to concatenate a semi colon to each record? If yes you can
use a "helper" column with the formula =A1&";" then copy and paste that
to accommodate the 500+ records. If you want a single string that
contains the 500 records we'll need to address that differently.