Newbie request: please help. Concatenate problem

  • Thread starter Thread starter Lionel Peach
  • Start date Start date
L

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
 
If the third column is C, add the following formula to C1:

=(A1&B1)

Then copy the formula down to the last row.
 
Back
Top