I have a column that has about 500 individual records. I want to take each
record and make a text string, semi colon delimited of all 500+ records. Is
there an easy way to do this?

tia,
--
JMorrell

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.

Now that I think about it, I believe this is a two step process. I can
concatenate a semi colon to the end of a cell value. After that, I need to
string together every value, with the semi colon, into a long string.

e.g. cell A1 contains "Jerry", cell A2 = "Joe", A3 = "Joan"

I want the string to be "Jerry; Joe; Joan;" Keep in mind that there are
over 500 cells that I want to string together.

This will eventually be used as a continuous string for another application.
Maybe I shouldn't be using Excel... any other suggestions?
--
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.

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.