Concatenate

[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

[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

"tbobo" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

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

"tbobo" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[tbobo]

Troy! thanks! it works for me!

[Anne Troy]

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

"tbobo" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>