Concatenate

T

tbobo

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
 
A

Anne Troy

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
 
B

Barb Reinhardt

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)
 
Top