Concatenate
 

col1 col2

1 1,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,",",A2,",",A3,",",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: http://www.excelforum.com/member.php...o&userid=31530
View this thread: http://www.excelforum.com/showthread...hreadid=512511

Concatenate
 

If 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 "quickie" concatenation method is (no need for
that long word nobody remembers how to spell):
=A1&A2&A3&A4....

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

"tbobo" wrote in
message ...

col1 col2

1 1,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,",",A2,",",A3,",",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:
http://www.excelforum.com/member.php...o&userid=31530
View this thread: http://www.excelforum.com/showthread...hreadid=512511

Concatenate
 

I've also done this:

A1: 1
A2: 2 B2: =A1&","&A2
A3: 3 B3 = B2&","&A3 (copy this down)
A4: 4 B4 = B3&","&A4 (and so on)

"tbobo" wrote in
message ...

col1 col2

1 1,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,",",A2,",",A3,",",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:
http://www.excelforum.com/member.php...o&userid=31530
View this thread: http://www.excelforum.com/showthread...hreadid=512511

Concatenate
 

Troy! thanks! it works for me!


--
tbobo
------------------------------------------------------------------------
tbobo's Profile: http://www.excelforum.com/member.php...o&userid=31530
View this thread: http://www.excelforum.com/showthread...hreadid=512511

Concatenate
 

You're welcome! :)
So glad I could help.
************
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"tbobo" wrote in
message ...

Troy! thanks! it works for me!


--
tbobo
------------------------------------------------------------------------
tbobo's Profile:
http://www.excelforum.com/member.php...o&userid=31530
View this thread: http://www.excelforum.com/showthread...hreadid=512511