Newbie request: please help. Concatenate problem

[Lionel Peach]

Hello Group

I am trying to concatenate two columns of about 400 rows of data like
this in to a thrid column.

0/ 1 0/1
0/ 2 0/2
.. .
.. .
.. 127 0/127

1/ 1 1/1
1/ 2 1/2
.. .
.. .
.. 127 1/127

2/ 1 2/1
2/ 2 2/2
.. .
.. .
.. 127 2/127

etc.

What is the easiest way to do this with ONE concatenate() function so
that I don't have to type it 400 times?

Thanks so much

Lionel

 

[Candice Mesk]

If the third column is C, add the following formula to C1:

=(A1&B1)

Then copy the formula down to the last row.

 

[Lionel Peach]

On Sun, 04 Jan 2004 17:23:28 GMT, Lionel Peach <[email protected]>
wrote:

Thank you Candace!