software

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 quot;helperquot; column with the formula =A1amp;quot;;quot; 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 quot;Jerryquot;, cell A2 = quot;Joequot;, A3 = quot;Joanquot;

I want the string to be quot;Jerry; Joe; Joan;quot; 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?
--
JMorrellquot;Dave Oquot; wrote:

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

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!

--
JMorrellquot;Dave Oquot; wrote:

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