software

col1 col2

11,2,3,4
2
3
4

I have data in col1 and I want to transfer the data into col2 with this
lay out :

1,2,3,4

I used this syntax:

=CONCATENATE(A1,quot;,quot;,A2,quot;,quot;,A3,quot;,quot;,A4)

Questions:

Is there a better way to create a short program to do this? assuming
my data is 1 to 500

Thanks--
tbobo
------------------------------------------------------------------------
tbobo's Profile: www.excelforum.com/member.php...oamp;userid=31530
View this thread: www.excelforum.com/showthread...hreadid=512511If you want my opinion, I would save the file as text. Then I would open it
in Word.
Ctrl H.
In the Find what, type ^p
In the Replace with, type a comma
Replace all.
But you should also know a quot;quickiequot; concatenation method is (no need for
that long word nobody remembers how to spell):
=A1amp;A2amp;A3amp;A4....

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

quot;tboboquot; gt; wrote in
message ...
gt;
gt; col1 col2
gt;
gt; 1 1,2,3,4
gt; 2
gt; 3
gt; 4
gt;
gt; I have data in col1 and I want to transfer the data into col2 with this
gt; lay out :
gt;
gt; 1,2,3,4
gt;
gt; I used this syntax:
gt;
gt; =CONCATENATE(A1,quot;,quot;,A2,quot;,quot;,A3,quot;,quot;,A4)
gt;
gt; Questions:
gt;
gt; Is there a better way to create a short program to do this? assuming
gt; my data is 1 to 500
gt;
gt; Thanks
gt;
gt;
gt; --
gt; tbobo
gt; ------------------------------------------------------------------------
gt; tbobo's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31530
gt; View this thread: www.excelforum.com/showthread...hreadid=512511
gt;
I've also done this:

A1: 1
A2: 2 B2: =A1amp;quot;,quot;amp;A2
A3: 3 B3 = B2amp;quot;,quot;amp;A3 (copy this down)
A4: 4 B4 = B3amp;quot;,quot;amp;A4 (and so on)

quot;tboboquot; gt; wrote in
message ...
gt;
gt; col1 col2
gt;
gt; 1 1,2,3,4
gt; 2
gt; 3
gt; 4
gt;
gt; I have data in col1 and I want to transfer the data into col2 with this
gt; lay out :
gt;
gt; 1,2,3,4
gt;
gt; I used this syntax:
gt;
gt; =CONCATENATE(A1,quot;,quot;,A2,quot;,quot;,A3,quot;,quot;,A4)
gt;
gt; Questions:
gt;
gt; Is there a better way to create a short program to do this? assuming
gt; my data is 1 to 500
gt;
gt; Thanks
gt;
gt;
gt; --
gt; tbobo
gt; ------------------------------------------------------------------------
gt; tbobo's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31530
gt; View this thread: www.excelforum.com/showthread...hreadid=512511
gt;

Troy! thanks! it works for me!--
tbobo
------------------------------------------------------------------------
tbobo's Profile: www.excelforum.com/member.php...oamp;userid=31530
View this thread: www.excelforum.com/showthread...hreadid=512511You're welcome!
So glad I could help.
************
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

quot;tboboquot; gt; wrote in
message ...
gt;
gt; Troy! thanks! it works for me!
gt;
gt;
gt; --
gt; tbobo
gt; ------------------------------------------------------------------------
gt; tbobo's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31530
gt; View this thread: www.excelforum.com/showthread...hreadid=512511
gt;