I saved file as .txt, then
opened in Word, then
found and deleted all carriage returns
replacing the carriage returns with a space

thanks for your help!

--
JMorrell


"Dave O" wrote:

> 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.
>
>